Thread: Date entries
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sal Iaccarino
 
Posts: n/a
Default Date entries

I was enter dates of birth in a column as month/date/year. The year was
entered as two digits. 2/7/31 appeared in cell as 2/7/1931.

However, once I got below 1930 and entered a date as 2/1/29, it appeared in
the cell as 2/1/2029. Can you tell me what was happening?

Sal and Eileen