Thread: how do I change the date format from yyyymmdd to mm/dd/yyyy
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default how do I change the date format from yyyymmdd to mm/dd/yyyy
DataText to ColumnsNextNextColumn Data FormatDateYMD and Finish


Gord Dibben MS Excel MVP

On Wed, 16 Sep 2009 09:09:01 -0700, Charlene
wrote:

how do I change the date format from yyyymmdd to mm/dd/yyyy

Reply With QuoteReply With Quote