Date formats [Solved/Closed]

- - Latest reply: ac3mark
Posts
10921
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 10, 2018
- Feb 22, 2017 at 06:25 PM
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



See more 

2 replies

Posts
10921
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 10, 2018
0
Thank you
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
2435
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 4, 2018
0
Thank you
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
ac3mark
Posts
10921
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 10, 2018
-
Thank you sir, I obviously didn't test it, but was working from memory. You da man!