PC Review


Reply
Thread Tools Rate Thread

Dates prior to 1900 are text

 
 
xp
Guest
Posts: n/a
 
      4th Mar 2010
Excel 2007 doesn't recognize dates prior to 1900. Dates entered prior to 1900
are not formatted as dates, but seem to become text. I can't do calculations
between such dates...what gives?

Anyone know how to over come this horrible limitation?



 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      4th Mar 2010
John Walkenbach has an addin that may help you:
http://j-walk.com/ss/excel/files/xdate.htm

xp wrote:
>
> Excel 2007 doesn't recognize dates prior to 1900. Dates entered prior to 1900
> are not formatted as dates, but seem to become text. I can't do calculations
> between such dates...what gives?
>
> Anyone know how to over come this horrible limitation?
>
>


--

Dave Peterson
 
Reply With Quote
 
Gary''s Student
Guest
Posts: n/a
 
      4th Mar 2010
see:

http://j-walk.com/ss/excel/files/xdate.htm


--
Gary''s Student - gsnu201001


"xp" wrote:

> Excel 2007 doesn't recognize dates prior to 1900. Dates entered prior to 1900
> are not formatted as dates, but seem to become text. I can't do calculations
> between such dates...what gives?
>
> Anyone know how to over come this horrible limitation?
>
>
>

 
Reply With Quote
 
Autor
Guest
Posts: n/a
 
      4th Mar 2010
You need to treat that dates as numbers and at the end present the result as
a text that looks like a date.


"xp" wrote:

> Excel 2007 doesn't recognize dates prior to 1900. Dates entered prior to 1900
> are not formatted as dates, but seem to become text. I can't do calculations
> between such dates...what gives?
>
> Anyone know how to over come this horrible limitation?
>
>
>

 
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
Re: Dates prior to 1900? =?Utf-8?B?SmltIEou?= Microsoft Access 0 19th Sep 2005 02:11 PM
Dates prior to 1900 =?Utf-8?B?S2lyaw==?= Microsoft Excel Worksheet Functions 3 22nd Nov 2004 02:49 AM
Dates prior to 1900 Joan Microsoft Excel Worksheet Functions 2 18th Sep 2004 07:48 PM
Dates prior to 1900 Jugglertwo Microsoft Excel Misc 2 7th Jul 2004 05:10 PM
Dates prior to 01-Jan-1900 Carl Hilton Microsoft Excel Misc 2 24th Mar 2004 07:39 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:53 AM.