Forum Discussion

Copper Contributor

Jul 19, 2019

dates in excel wont format correct

i had a spreadsheet with dates formatted as yyyymmdd, I now need to change them to mm/dd/yyyy. before starting this a user began keying all changes in the new format, so when you looked at the data ...

Formulas and Functions

nabilmourad

MVP

Jul 19, 2019

kgoldie

This could be fixed in Power Query.

Convert your data into a table (CTRL +T) >> Enter
On the Data Tab >> Select From Table
The Query Editor opens
Select the Date Column having the Problem
Click on the ADD Column tab
To the right side >> Click on Date >> Select "Date"
Now the Dates are fixed in the new Column
Right Click the original Date column >> remove Column
On the Home Tab >> Click Close and Apply

Hope that helps

Nabil Mourad