I want to be able to enter 011707 into a cell and have it change it to 01/17/07. I cannot seem to remember how to get this to work. I have changed the format to in the cells to date and tried custom settings but I always get something like 1/19/32 as the date.

Thanks for any help.