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

[Ellen M]

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

 

[Jon Peltier]

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

- Jon