type date without slashes

[eugz]

Hi All.
I format cells in my spreapsheet like MM/DD/YYYY and typed 122606 but got not the same date like expected. Is it possible type number of date without slashes and receive correct date value?
Thanks.

 

[unmarkedhelicopter]

you'd need to monitor selected cells, and when a 6 digit number is entered covert that to a date using a worksheet/workbook event. The problem start arising when your number starts with a 0.