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

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - In any format, all my dates in 2000 change to 1900. How do I fix (https://www.excelbanter.com/charts-charting-excel/254644-any-format-all-my-dates-2000-change-1900-how-do-i-fix.html)

Ellen M

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

In any date format all dates in the year 2000 and on change to 1900. How do
I fix?

Jon Peltier[_2_]

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

Make sure Excel knows these are dates, and isn't treating them as text.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/

Ellen M wrote:
In any date format all dates in the year 2000 and on change to 1900. How do
I fix?

All times are GMT +1. The time now is 07:43 PM.