G
Guest
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.
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.