Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel wants to change it for me, every time. The cell is formatted as
Text. How do I suppress this feature? I can't find it in Options. Thanks! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You can find it on Tools | Autocorrect - it is the first one listed on
my XL 2000. Just remove it from the list of autocorrections. Hope this helps. Pete On Feb 29, 5:40*pm, frank megaweege wrote: Excel wants to change it for me, every time. *The cell is formatted as Text. How do I suppress this feature? *I can't find it in Options. Thanks! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Feb 29, 12:44*pm, Pete_UK wrote:
You can find it on Tools | Autocorrect - it is the first one listed on my XL 2000. Just remove it from the list of autocorrections. Hope this helps. Pete It absolutely does help. Many thanks. On Feb 29, 5:40*pm, frank megaweege wrote: Excel wants to change it for me, every time. *The cell is formatted as Text. How do I suppress this feature? *I can't find it in Options. Thanks!- Hide quoted text - - Show quoted text - |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Another option is to press CTRL + Z to undo the autocorrect option.
This will only work after the next key is tapped and will not work after enter is pressed. HTH Martin "frank megaweege" wrote in message ... On Feb 29, 12:44 pm, Pete_UK wrote: You can find it on Tools | Autocorrect - it is the first one listed on my XL 2000. Just remove it from the list of autocorrections. Hope this helps. Pete It absolutely does help. Many thanks. On Feb 29, 5:40 pm, frank megaweege wrote: Excel wants to change it for me, every time. The cell is formatted as Text. How do I suppress this feature? I can't find it in Options. Thanks!- Hide quoted text - - Show quoted text - |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You're welcome, Frank - thanks for feeding back.
Pete On Feb 29, 5:49*pm, frank megaweege wrote: On Feb 29, 12:44*pm, Pete_UK wrote: You can find it on Tools | Autocorrect - it is the first one listed on my XL 2000. Just remove it from the list of autocorrections. Hope this helps. Pete It absolutely does help. *Many thanks. On Feb 29, 5:40*pm, frank megaweege wrote: Excel wants to change it for me, every time. *The cell is formatted as Text. How do I suppress this feature? *I can't find it in Options. Thanks!- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |