Inserting slashes in dates in Excel
DataText to ColumnsDelimitedNextNextDate choose YMD and OK
Gord
On Tue, 28 Jan 2014 16:54:26 +0000, Sophster
wrote:
I have a column of dates in the format: yyyymmdd
ie. 20110731
I would like to convert this to a date format that is sortable:
ie. 2011/07/31
Could you tell me how to do this?
Thanks,
Sophster
|