| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date is automatically converting
I formated a group of cells to be dates seclecting the "date" category and
then selecting "03/14/01" type. But when I key 120199 in one of the formatted cells it converts it to 02/02/29. When I key 120199 I expect it to display 12/01/99. Why does Excell convert it? And how do I stop it from doing so? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert date automatically | Excel Discussion (Misc queries) | |||
| Automatically Add in 56days to the date | Excel Discussion (Misc queries) | |||
| How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
| How do I automatically calculate YTD numbers by changing a date? | Excel Worksheet Functions | |||
| Converting a date in Excel 2002 to a Year/Quarter format | Excel Worksheet Functions | |||
Threaded Mode
