| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I stop Excel Advancing the year by 1 when I enter a date?
I did something which caused a problem with entering dates in Excel. When I
enter a date, it looks fine until I leave the cell. Then the year advances by one. For example if I type in 05/05, when I tab out the cell displays May-06. I have tried right clicking on the cell and selecting the mmmyy selection, but it makes no difference. I also selecting from tried the format dropdown menu. Nothing changed it. the only way I could enter a date and have it stay as entered was to put a quote mark before the numbers. what did I do to cause this problem and how can i fix it? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop a general format from being autoformatted to date | New Users to Excel | |||
| in excel how do enter today's date on a laptop | New Users to Excel | |||
| Excel default date format | Excel Discussion (Misc queries) | |||
| How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
| How do I enter a date in excel without "/" ex. 041504 will show 0. | Excel Discussion (Misc queries) | |||
Threaded Mode
