If the day always have 2 digits so that 06/01/00 displays as 60100 then the
best way is not formulas, just select the column
do datatext to columns. click next twice to get to step 3, select Date
under column data format and select MDY, click finish

Regards,

Peo Sjoblom

"date cell configuration" wrote:

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