Did you try that? It will not work

--
Regards,

Peo Sjoblom


"Farhad" wrote in message
...
Hi,

right click on the cell you want to format choos format cells and then
choos
number tab and then choos custom and then enter in the type textbox mmddyy
but it formats Jan 1, 2007 to 010107 not 10107.

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?