Hi again,

it was a missunderestood try this:

A B
1 10107 =IF(LEN(A1)=5,"0"&A1,LEFT(A1,6))
2 110107

enter above formula in the cell B1 ( in this example ) and the copy drag the
formula to where you need and then copy past special value the formula that
you copied and then go to menudatatext to column and then choos Delimited
and next and coos other and enter / in the text box and next and choos MDY
from drupdown menu and Finish.

Thanks,
--
Farhad Hodjat


"Teri" wrote:

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?