Thread: Convert Numbers to Dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DOUG ECKERT[_2_] DOUG ECKERT[_2_] is offline
external usenet poster
  
Posts: 66
Default Convert Numbers to Dates
How would I convert the number below to a date format?

010306

It should come out looking like 01-Jan-06.

(DATE and DATEVALUE functions did not seem to work as advertised).
Reply With QuoteReply With Quote