Awesome!! Perfect! Thank you for your help :)

"PCLIVE" wrote:

Certainly there must be another way, but here's one way. Format your cells
as Date and the desired format.

=(LEFT(LEFT(A1,LEN(A1)-2),LEN(LEFT(A1,LEN(A1)-2))-2)&"/"&RIGHT(LEFT(A1,LEN(A1)-2),2)&"/"&RIGHT(A1,2))+0


"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?