00/01/1900

  • Thread starter Thread starter batterseamike
  • Start date Start date
B

batterseamike

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 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
 
Back
Top