Forum Discussion
Solved
Date Format in Excel
I have an excel file with roughly 15k records and I have several different date formats showing up in my date column. The information comes from a variety of different sources, and this is why I have...
Hi Dave,
To convert dates select the column with them, in ribbon Data->Text to columns, parameters on first two steps of the wizard doesn't matter, on third step select Date with MDY format
As the destination here I selected another column, but you may replace selected one (=$A$1 in this case).
Result is
I use ISO dates format, but you may apply MM/DD/YYYY if it's not default one.
Thank you both for your responses. Greatly appreciated.