Assistance with date formula

Closed
Logan - Jun 19, 2015 at 12:51 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 19, 2015 at 04:49 PM
Hello,

I got a whole lot of data saved as dd/mm/yyyy - need them to be converted to read yyyy/mm/dd - any ideas?

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jun 19, 2015 at 04:49 PM
Logan, Good afternoon.

Select the cell with the date.
--> Menu Format
--> Cells
--> Number
--> Custom
--> Below the word Type: on the field.
--> Type yyyy/mm/dd

Is it what you want?
I hope it helps.
0