View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
 
Posts: 621
Default 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