| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Change the low date range regional setting.
In genealogy I need to list the 4-digit year. I'm trying to create a
spreadsheet that sorts on date. The low end of the date range in regional settings is 1930. I need to push this back to make excel recognize the older dates. How do I do it? |
|
#2
|
|||
|
|||
|
Enter a 4 digit year when you enter the data.
But excel doesn't see dates before January 1, 1900. John Walkenbach has an addin you may want to get if you're dealing with dates before 1900. http://j-walk.com/ss/excel/files/xdate.htm genesearcher wrote: In genealogy I need to list the 4-digit year. I'm trying to create a spreadsheet that sorts on date. The low end of the date range in regional settings is 1930. I need to push this back to make excel recognize the older dates. How do I do it? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help: Can I change the date formula from mm/dd/yyyy to "mmm-yy" et | Excel Discussion (Misc queries) | |||
| change value by date range | Excel Worksheet Functions | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
| HOW TO USE A FORMULA TO CHANGE CELL COLOR ACCORDING TO DATE RANGE. | Excel Worksheet Functions | |||
| How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions | |||
Linear Mode
