Report

Date formats [Solved]

Ask a question jbeasley - Last answered on Feb 22, 2017 at 06:25 PM by ac3mark
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 
Helpful
+0
plus moins
I believe it goes something like:
=text("yyyy-mm-dd")
Post back!

Have fun!
Leave a comment
Helpful
+0
plus moins
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 6807Posts Monday June 3, 2013Registration date ModeratorStatus April 25, 2017 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!
Reply
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!