Assistance with date formula

Closed
Logan - 19 Jun 2015 à 12:51
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 19 Jun 2015 à 16:49
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 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
19 Jun 2015 à 16:49
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.