View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Trouble Entering Old Date Formats

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