Date Format Long Description

I have one columns contains date only, and the type of column is โ€œDateโ€

The information is showing long form โ€œWed Sep 16 2020 00:00:00 GMT+0400 (Gulf Standard Time)โ€

I need to show only the Date!

Solved Solved
0 3 143
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

Where is it showing this? If in your spreadsheet, change the format for the entire spreadsheet column to plain text. In general, it is advisable to change the entire spreadsheetโ€™s cell format to plain text.

View solution in original post

3 REPLIES 3

Turn long format option off from the column details

It was already off, the issue was that in google sheet the column is formatted as date, as Steve explained
I made all columns Plain Text, it worked perfect.

Thanks LeventK for your advise.

Steve
Platinum 4
Platinum 4

Where is it showing this? If in your spreadsheet, change the format for the entire spreadsheet column to plain text. In general, it is advisable to change the entire spreadsheetโ€™s cell format to plain text.

Top Labels in this Space