You could format the entry cells as text and use a column next to them
to display a date by parsing the text. If the text were in M2, N2
would contain (=LEFT(M2,2)&"/"&MID(M2,3,2)&"/"&RIGHT(M2,2)

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=528648