In any format, all my dates in 2000 change to 1900. How do I fix

  • Thread starter Thread starter Ellen M
  • Start date Start date
E

Ellen M

In any date format all dates in the year 2000 and on change to 1900. How do
I fix?
 
Make sure Excel knows these are dates, and isn't treating them as text.

- Jon
 
You must log in or register to reply here.

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

Please help! date showing as 1900/01/00 2
Error in Excel date calculations 3
Date format problems 1
How do I show yyyy only on x axis of a chart? 4
How do I plot "Month, Year" on the x-axis for prior to 1900? 2
X Y Scatter Chart - Dates on X axis starting at 1900 1
permanent conversion of 1904 date format to 1900 date format 3
Dates prior to 1900 are text 3

Back
Top