View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Formatting Cells with Dates

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"