Hi,

I want to enter and format dates prior to 1901 so that I can calculate ages
on a family history research page. Without looking too hard I think that
dates start around 1900 and when i enter dates in the 1800s, I cant enter
them in any date format as they only seem to enter as general text. Having
picked up numerous tips from this site, Im sure someone will have a simple
explanation for me as to what I am overlooking. VMT
--
Joroti

With an addin

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

Mike

"JRTB" wrote:

Hi,

I want to enter and format dates prior to 1901 so that I can calculate ages
on a family history research page. Without looking too hard I think that
dates start around 1900 and when i enter dates in the 1800s, I cant enter
them in any date format as they only seem to enter as general text. Having
picked up numerous tips from this site, Im sure someone will have a simple
explanation for me as to what I am overlooking. VMT
--
Joroti

See John Walkenbach's site for an add-in.

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


Gord Dibben MS Excel MVP

On Tue, 24 Jul 2007 00:52:02 -0700, JRTB wrote:

Hi,

I want to enter and format dates prior to 1901 so that I can calculate ages
on a family history research page. Without looking too hard I think that
dates start around 1900 and when i enter dates in the 1800s, I cant enter
them in any date format as they only seem to enter as general text. Having
picked up numerous tips from this site, Im sure someone will have a simple
explanation for me as to what I am overlooking. VMT