View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Lee Lee is offline
external usenet poster
 
Posts: 38
Default Imported Date Format

I have imported data from an accounting program and the date format is
20070101 for January 1, 2007. I have looked at various sites that would use
Left(),Mid(),Right() to break the numbers and then put them back into
2007/01/01 but was wondering if anyone had a simpler solution.
Thanks,
Lee Coleman