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.

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.