PC Review


Reply
Thread Tools Rate Thread

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

 
 
Ellen M
Guest
Posts: n/a
 
      27th Jan 2010
In any date format all dates in the year 2000 and on change to 1900. How do
I fix?
 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      28th Jan 2010
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?

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:44 PM.