How do I change the format "YY/MM/DD" to show as "MM/DD/YY"?

Closed
Guest3309 - 22 Dec 2014 à 17:37
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 22 Dec 2014 à 21:51
Hello,

I have a spreadsheet that I need to convert the date fields from the format "YY/MM/DD" to read as "MM/DD/YY". For example, if the field currently shows as "14/08/31", i want it to show as "08/31/14". (August 31st, 2014).

Please help!!

Thank you!
Related:

2 responses

I. Can fix ithitman
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
22 Dec 2014 à 21:51
Guest3309, Good evening.

If your data as stored as DATE use a CELL FORMAT Menu.

Select Cell
Cell Format Menu
Date --> Custom --> MM/DD/YY

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão