hi,
you might try a formula like this....
=LEFT(B3,1) & "/" & MID(B3,2,2) &"/" & RIGHT(B3,4)
I tried it on the example you gave and it took. and is treated by excel as a
date because i can add 1 to the results and get 1/2/2007.

regards
FSt1

"billbrandi" wrote:

A file I download from a mainframe has date data in it in a ddmmyyyy format.
Example, 1/1/2007 comes across as 1012007. How do I convert to a dd/mm/yyyy
format?

Thanks
Bill Falzone