Converting Date Format Using Text To Columns

May 25, 2013

A customer sent through a spreadsheet with what appeared to be dates displayed in column A in the format YYYY-MM-DD. The spreadsheet was the result of a data export from a bespoke system and the “dates” were actually text entries. The customer wanted the...