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

's Computer Specifications

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

's Computer Specifications

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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
dates before 1900	JLH	Microsoft Excel Discussion	2	8th Nov 2008 09:21 PM
convert Excel sheet in 1904 format to 1900 without changing dates	=?Utf-8?B?Sm9l?=	Microsoft Excel Worksheet Functions	1	8th Jun 2007 01:51 PM
can I format dates older than 1900	=?Utf-8?B?ZGVtYW5nZW8=?=	Microsoft Excel Worksheet Functions	1	8th Jul 2005 12:55 AM
how do I get excel to format dates before 1 jan 1900	=?Utf-8?B?a2VpdGhjYXJ0ZXJ1aw==?=	Microsoft Excel Misc	1	3rd Feb 2005 05:23 PM
Dates pre 1900	Kerry Frater	Microsoft Excel Misc	1	5th Dec 2003 05:38 PM