Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text Problem
I have a problem in my workbook that the cells will not accept the three
text digits of ACN but instead changes it to CAN.What could cause this to happen? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text Problem
Goto ToolsAutocorrect options...
scroll down the list, odds are there is an entry for ACN that gets changed to CAN. delete it. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "jk" wrote in message ... I have a problem in my workbook that the cells will not accept the three text digits of ACN but instead changes it to CAN.What could cause this to happen? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text Problem
From the Excel main menu:
<tools<options<spelling tab Click the [AutoCorrect Options...] button Search the "Replace" list for ACN Delete it from the list Does that help? *********** Regards, Ron XL2002, WinXP "jk" wrote: I have a problem in my workbook that the cells will not accept the three text digits of ACN but instead changes it to CAN.What could cause this to happen? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text Problem
jk wrote: I have a problem in my workbook that the cells will not accept the three text digits of ACN but instead changes it to CAN.What could cause this to happen? That is an example of AutoCorrect. You can go to Tools Options Spelling autocorrect options to play around with the settings. The rule acn -can is one of the rules that can be deleted if need be. You could turn off autocorrection all together if you want. -semiopen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif - problem counting text, other text | Excel Worksheet Functions | |||
Text Box problem | Excel Discussion (Misc queries) | |||
Large amount of text in cells - Problem text.xls (0/1) | Excel Discussion (Misc queries) | |||
Large amount of text in cells - Problem text.xls (1/1) | Excel Discussion (Misc queries) | |||
lots of text in text box problem | Excel Programming |