Thread: How can I change 080402 to 08/04/02?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How can I change 080402 to 08/04/02?
DataText to ColumnsNextNextColumn Data FormatDateDMY and Finish.


Gord Dibben MS Excel MVP

On Fri, 3 Nov 2006 12:07:02 -0800, Bobbie
wrote:


Reply With QuoteReply With Quote