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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Dec 22, 2014 at 09:51 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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!
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:
- How do I change the format "YY/MM/DD" to show as "MM/DD/YY"?
- Mm/yy - Guide
- How to change inches to mm in adobe acrobat - Guide
- How to change free fire facebook account to google account - Guide
- How to change language in kmplayer - Guide
- Format factory - Download - Other
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Dec 22, 2014 at 09:51 PM
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
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