Convert number to date
datatext to columns, click next twice in step 3 under column data format
select date and make sure it is MDY, then click finish
--
Regards,
Peo Sjoblom
"Teri" wrote in message
...
I am importing data from an AS400 program and my dates are formated as
10107
for January 1, and would be 110107 for November 1. Can anyone help me
figure
out out to convert to 1/01/07 and 11/01/07?
|