| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date default error after 1999
Date format mmm-yy changes entries to mmm-06 for any date after 1999, as does
month-yy and m-yy. All dates prior to 12/31/99 work correctly in these three formats. All other date formats work correctly. Is a setting off somewhere? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Default Date Format | Setting up and Configuration of Excel | |||
| How change Excel default date format to something useful | Excel Discussion (Misc queries) | |||
| Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
| Default date formats | New Users to Excel | |||
| date and time | New Users to Excel | |||
Threaded Mode
