Thread: how to change number to date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default how to change number to date
Probably the best is:

=date(mod(a1,10000),mod(int(a1/10000),2),day(int(a1/1000000)))

This will handle the case where you have two digit dates.

Regards
Fred

"Happy One" <Happy wrote in message
...
How to change the number 1122008 to 1/12/2008?

Reply With QuoteReply With Quote