| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a date be used for conditional formatting? | Excel Worksheet Functions | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
| Btwn to date entries | Excel Worksheet Functions | |||
Threaded Mode
