00/01/1900
 

I have tried to format a column in an excel worksheet to show dates but
whatever I type in, it always shows 00/01/1900. This is happening on one
sheet only, others record what I type in without any problem but seem to be
formatted in the same way as the sheet giving wrong output. HELP, I'm going
mad trying to figure it out!

00/01/1900
 

00/01/1900 is what Excel displays when the cell has the number zero in it.
Are you actually typing data into that cell? Or do you have a formula which
is always resulting in zero?

Regards,
Fred

"batterseamike" wrote in message
...
I have tried to format a column in an excel worksheet to show dates but
whatever I type in, it always shows 00/01/1900. This is happening on one
sheet only, others record what I type in without any problem but seem to
be
formatted in the same way as the sheet giving wrong output. HELP, I'm
going
mad trying to figure it out!