Forum Discussion

Brass Contributor

Sep 16, 2020

Changing date format

I am getting my dates in this format, 2020-09-15 and would like to convert to 09/15/2020, is there a way to do that. I tried all options I have under custom format, but nothing worked. I have attache...

Planned to Actual Relieved.xlsx2.7 MB

excel

Rajesh_Sinha

Iron Contributor

Sep 17, 2020

This will not work, since date are Formatted as TEXT,, check my post,,, suggested MACRO.

NikolinoDE

Gold Contributor

Sep 17, 2020

Rajesh_Sinha

You are absolutely right, once again, has shown that first read and then write, can work wonders.

Convert dates stored as text to dates

https://support.microsoft.com/en-gb/office/convert-dates-stored-as-text-to-dates-8df7663e-98e6-4295-96e4-32a67ec0a680?ui=en-us&rs=en-gb&ad=gb

Thanks for the hint

Nikolino

I know I don't know anything (Socrates)