View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JJMCDD02
 
Posts: n/a
Default How do I convert a text string into a date?

I am downloading a .CSV file which includes date info, stored as text (form
is: yyyymmdd120000[0:GMT]), and I want to convert it to a date recognized by
Excel. P.S. I don't mind chopping off the '120000[0:GMT]' string by using
the REPLACE command, but converting the remaining yyyymmdd string has got me
stumped! Thanks.