Thread: how to convert 19900301 to 03/01/1990
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default how to convert 19900301 to 03/01/1990
Use the DATE() function:

If 19900301 is in A1 then =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
will get you the value in date form.
--
Gary''s Student


"clarice" wrote:

how can a date that is set up in excel as 19900301 be converted automatically
to read 03/01/1990?
Reply With QuoteReply With Quote