No dates before 1900?!

[JMF]

A friend is organizing some data in Excel, which includes letters written in
the 1800s. So there are the correspondents, notes, etc., and the dates.

She told me Excel doesn't handle dates earlier than 1900!

I found this hard to believe, so I tested it. Sure enough, if I put a date
1900 or later, it allows me to format the cell any way I want, calculates
the day, whatever. With a date earlier than that, it accepts the date, but I
can't do anything with it.

Any way around this?

Thanks!

John

 

[Paul B]

John, have a look here for information on working with pre-1900 dates

http://j-walk.com/ss/excel/usertips/tip028.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[davesexcel]

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

XDate: Extended Date Functions Add-In

Here's an Add-in from J-Walk, that will let you work with dates before
1900

 

[JMF]

Paul and Dave,

!!!! Well how about that !!!!

Thanks a million,

John