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

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?

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

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"SSA KO" wrote:
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?