View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Greg Greg is offline
external usenet poster
 
Posts: 331
Default Date Manipulation

I have a report that come out of our system as a general formatted cell but
the information is a European date format (i.e. 20061101 for Nov 1st). Is
there a way to get that data into a US date format for sorting and days
between function ability?

Thanks in Advance