Date formats [Solved/Closed]

Report
-
 Blocked Profile -
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



2 replies

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
Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
448
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
Blocked Profile
Thank you sir, I obviously didn't test it, but was working from memory. You da man!