How do I change my date from this format 20070507 to 05/07/07?

S

SSA KO

How do I change my date from this format 20070507 to 05/07/07? My Data
retrieval program puts my date in this format YYYYMMDD. I can't figure out
how to to change it to MM/DD/YY. Can any one help?
 
M

Max

Those are probably not real dates. Use Data > Text to Columns on the col of
dates. In step 3 of the wiz, check "Date" under "Column data format", then
select YMD from the droplist. Click Finish. Now you can format the real dates
to taste.
 
Top