View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Still learning@work Still learning@work is offline
external usenet poster
 
Posts: 12
Default Converting Dates after Import

I have imported employee data from an AS400. The text for dates import as
"1012008" for 01/01/08 or 12012008 for 12/01/08. Is it possible to write a
formula to insert the "/" for 4 spaces from the left and again at 6 spaces
from the left.

I need to be able to make these usable dates without speinding a lot of
time. Other suggestions for converting these to a workable date would be
appreciated.

Thank you for your help.