| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
why does the year 2006 appear as 2005?
When I enter the year 2006 in any worksheet, it appears as 2005. I can put a
comma infront, but dont really want to do this each time. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why does the year 2006 appear as 2005?
Have you looked at Tools/ Autocorrect Options?
-- David Biddulph "Nat" wrote in message ... When I enter the year 2006 in any worksheet, it appears as 2005. I can put a comma infront, but dont really want to do this each time. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why does the year 2006 appear as 2005?
Hi David, that worked just fine! I have no clue why it was set to replace
2006 with 2005. Thanks! "David Biddulph" wrote: Have you looked at Tools/ Autocorrect Options? -- David Biddulph "Nat" wrote in message ... When I enter the year 2006 in any worksheet, it appears as 2005. I can put a comma infront, but dont really want to do this each time. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why does the year 2006 appear as 2005?
Glad it worked for you.
-- David Biddulph "Nat" wrote in message ... Hi David, that worked just fine! I have no clue why it was set to replace 2006 with 2005. Thanks! "David Biddulph" wrote: Have you looked at Tools/ Autocorrect Options? "Nat" wrote in message ... When I enter the year 2006 in any worksheet, it appears as 2005. I can put a comma infront, but dont really want to do this each time. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I combine monthly dates ex: jan 1,2005+jan 1,2006 together. | Excel Discussion (Misc queries) | |||
| 2005 to 2006 calendar? | Excel Worksheet Functions | |||
| Provide a UK tax calendar 2005-2006 on your web site | Charts and Charting in Excel | |||
| HOW DO I CHANGE ABSENCE TEMPLATE 2005, TO 2006 | Excel Worksheet Functions | |||
| excel calendar year resetting 2005 2006 | Excel Discussion (Misc queries) | |||
Hybrid Mode
