USING THE DATE FORMAT IN EXCEL

T

teach

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?
 
G

Gordon

teach said:
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?
Click to expand...

Try typing 12/14/04.........
 
D

Dave Peterson

I'm guessing that you really meant: 121404 (not 1121404).

If you have a column of data like this, you could select that column and do
Data|text to columns.
Choose fixed width (but remove any lines that excel guessed).
Choose mdy as the column format for that field.
 
Top