Thread: convert Numbers to Dates
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Hardeep kanwar[_2_] Hardeep kanwar[_2_] is offline
external usenet poster
  
Posts: 14
Default convert Numbers to Dates
Man you both are Life Saver

Thanks Both of you

Regards

Hardeep kanwar

"Gary''s Student" wrote:

=DATE(RIGHT(A1,4),LEFT(RIGHT(A1,6),2),LEFT(TEXT(A1 ,"00000000"),2))
with the proper format.
--
Gary''s Student - gsnu200903
Reply With QuoteReply With Quote