When i apply a date format to a cell and then type in a date......eg. 1121404
instead of giving me 12/14/04 it gives me some random date like 11/05/2265.
I have changed the date format from short to long ...changed the way I enter
it and even fooled with the default time setting for the computer.

Is their a way to correct this problem without using a formula?