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

Closed
Guest3309 - Dec 22, 2014 at 05:37 PM
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 - Dec 22, 2014 at 09:51 PM
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!

2 replies

I. Can fix ithitman
1
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Dec 22, 2014 at 09:51 PM
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
0