View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eqa Eqa is offline
external usenet poster
 
Posts: 52
Default Dates that need to be split into Year/MM/DD

I have a long list of dates in a column that are YYYYMMDD without any / or -
to break up the year, month,day How do I insert these breaks automatically?
Cell formating by date doesn't give me the the correct format. Thanks