teach wrote:
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?
Try typing 12/14/04.........
|