Date formats

Solved/Closed
jbeasley - Feb 17, 2017 at 04:42 PM
 Blocked Profile - 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



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
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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
0
Blocked Profile
Feb 22, 2017 at 06:25 PM
Thank you sir, I obviously didn't test it, but was working from memory. You da man!
0