Date formats
Solved/Closed
Related:
- Date formats
- How to change date format in excel - Guide
- How to change date format in openoffice - Guide
- Enable support for other file formats, such as pdf and xps - Download - Other
- Excel conditional formatting based on date - Guide
- Clear formats excel - Guide
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
Contributor
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
