Date formats
Solved/Closed
Related:
- Date formats
- Excel date format dd.mm.yyyy - Guide
- Whatsapp date format - Guide
- How to change date format in excel - Guide
- Openoffice date format - Guide
- Find add-ins for other file formats - Download - Other
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
552
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