00/01/1900


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!
 
Ad

Advertisements

F

Fred Smith

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top