I am creating a Family History data base on Excel and I cannot seem to get
the cells to format when the years are past 1900.
How do I format the cell to recognize....example 9/16/1898 to read as
"16-Sept-1898"

--
Thanks, lls53

See he http://ask.metafilter.com/mefi/42511

Essentially, pre-1900 dates cause problems for Excel. Try formatting those
dates as text.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"lls53" wrote:

I am creating a Family History data base on Excel and I cannot seem to get
the cells to format when the years are past 1900.
How do I format the cell to recognize....example 9/16/1898 to read as
"16-Sept-1898"

--
Thanks, lls53

See

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

In article ,
lls53 wrote:

I am creating a Family History data base on Excel and I cannot seem to get
the cells to format when the years are past 1900.
How do I format the cell to recognize....example 9/16/1898 to read as
"16-Sept-1898"