| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addendum to 2 digit year to 4 digit year
I'd also like to be able to sort on the basis of the 4 digit year. I an
incorrect reuslt where years from both centuries exist, such as an ascending sort having 2006 come before 1999 instead of the correct 1999 before 2006. -- I know enuff to be dangerous. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format 2 digit year to 4 digit | Excel Discussion (Misc queries) | |||
| Lookup returns wrong value | Excel Worksheet Functions | |||
| holiday dates | Excel Worksheet Functions | |||
| How do I get Excel to automatically calculate salaries actually received in financial year? | Excel Discussion (Misc queries) | |||
| 2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
Threaded Mode
