Thread: How do you change a date that is in the yyyymmdd format to mmddyy
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Miguel Zapico
 
Posts: n/a
Default How do you change a date that is in the yyyymmdd format to mmddyy
You can use a formula like this:
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
--
It is nice to be important, but it is more important to be nice


"Norton" wrote:

I have a spreadsheet that contains a date in the format of yyyymmdd and I can
not get it to convert to a different date format
Reply With QuoteReply With Quote