Date formats
Solved/Closed
Related:
- Date formats
- How to change date format in excel - Guide
- How to change date format in openoffice - Guide
- Clear formats excel - Guide
- Mp3 formats - Guide
- Excel date format dd.mm.yyyy - 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 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
21 Feb 2017 à 11:11
21 Feb 2017 à 11:11
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
