Hi

With date in A1, use formula in additional column to convert the number to
date:
=1*(LEFT(A1,LEN(A1)-4) & "/" & MID(A1,LEN(A1)-3,2) &"/" & RIGHT(A1,2))

NB! This works only, when your dates are currently in "format" 'mddyyyy' -
i.e.
11100 means always 1/11/00, and never 11/1/00. When contrary, then the only
way you have left is manual editing.


Arvi Laanemets


"date cell configuration" <date cell
wrote in message
...
Currently have thousands of cells entered as 61200 (June 12, 2000) or
101200
(October 12, 2000). When these cells are formated as a dates, the dates
show
incorrectly. To save time, need to format the cells as dates without
manually entering two / to seperate the groups of characters as 6/12/00 or
10/12/00.

Thanks