Thread: Convert date format from 20060801 to 1st Aug 2006 (or similar)?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Convert date format from 20060801 to 1st Aug 2006 (or similar)?
DataText to ColumnsNextNextColumn Data FormatDateYMD or YDM and Finish.


Gord Dibben MS Excel MVP

On Tue, 5 Sep 2006 02:54:02 -0700, excel_irate
wrote:

Does anybody know how to convert this (20060801) to a more user friendly
output?

Reply With QuoteReply With Quote