Date formats [Solved/Closed]

jbeasley - Feb 17, 2017 at 04:42 PM - Latest reply: ac3mark 9956 Posts Monday June 3, 2013Registration dateModeratorStatus July 18, 2018 Last seen
- 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 

3 replies

ac3mark 9956 Posts Monday June 3, 2013Registration dateModeratorStatus July 18, 2018 Last seen - Updated by ac3mark on 17/02/17 at 09:47 PM
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
TrowaD 2395 Posts Sunday September 12, 2010Registration date July 17, 2018 Last seen - Feb 21, 2017 at 11:11 AM
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 9956 Posts Monday June 3, 2013Registration dateModeratorStatus July 18, 2018 Last seen - Feb 22, 2017 at 06:25 PM
Thank you sir, I obviously didn't test it, but was working from memory. You da man!