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

Similar Threads

date corruption? 00/01/1900 2
2007 conditional formatting not playing ball 5
max value 1
Blank dates showing as 00 january 1900 - help 3
Date showing incorrect. 30:00 hrs showing 06:00 4
Formula Bar - display of content 6
Changing language for spell check not working? 1
Date format 01/00/00 1

Top