Date formats
Solved/Closed
Hello,
Can you tell me how to change the format from Sep-01-2015 to the format 2015-09-01? I have tried the format tab under the Date section and Custom section. Any and all assistance is greatly appreciated.
thanks in advance for your help
Can you tell me how to change the format from Sep-01-2015 to the format 2015-09-01? I have tried the format tab under the Date section and Custom section. Any and all assistance is greatly appreciated.
thanks in advance for your help
Related:
- Date formats
- Excel date format dd.mm.yyyy - Guide
- Enable support for other file formats, such as pdf and xps - Download - Other
- Whatsapp date format - Guide
- How to change date format in openoffice - Guide
- How to set date format dd-mm-yyyy in vivo ✓ - Office Software Forum
2 responses
I believe it goes something like:
=text("yyyy-mm-dd")
Post back!
Have fun!
It's kind of fun to do the impossible! -Walter Elias Disney
=text("yyyy-mm-dd")
Post back!
Have fun!
It's kind of fun to do the impossible! -Walter Elias Disney
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 21, 2017 at 11:11 AM
Feb 21, 2017 at 11:11 AM
Almost Mark, but you forgot to mention the cell reference.
=TEXT(A1;"yyyy-mm-dd")
But using yyyy-mm-dd in the custom section should work as well.
Best regards and indeed have fun,
Trowa
=TEXT(A1;"yyyy-mm-dd")
But using yyyy-mm-dd in the custom section should work as well.
Best regards and indeed have fun,
Trowa
