Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't enter characters, is some sort of auto-correct on?
I try to enter a stock symbol, "ACN" into a cell.
It enters CAN. My entry is all caps and no quotes. If i use a single quote, and enter 'ACN Excel still enters CAN. I have "ignore words in upper case" checked in proofing options. How can this reprehensible behavior be turned off????? Thanks, tom -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200904/1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't enter characters, is some sort of auto-correct on?
I have "ignore words in upper case" checked in proofing options.
You must be using Excl 2007. Office buttonExcel OptionsProofingclick the AutoCorrect options button In the Replace box type: acn That should select the autocorrect entry and it will be highlighted Click the Delete button OK This will delete that correction from *all* of the Office applications. They all share the same autocorrect library. -- Biff Microsoft Excel MVP "TomCon via OfficeKB.com" <u50688@uwe wrote in message news:94eba1a75ed1b@uwe... I try to enter a stock symbol, "ACN" into a cell. It enters CAN. My entry is all caps and no quotes. If i use a single quote, and enter 'ACN Excel still enters CAN. I have "ignore words in upper case" checked in proofing options. How can this reprehensible behavior be turned off????? Thanks, tom -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200904/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter info in one sheet, auto enter in another based on one field | New Users to Excel | |||
After Enter, go to correct cell | Excel Discussion (Misc queries) | |||
Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
cannot enter correct numbers in cells | Excel Worksheet Functions | |||
Enter CORRECT password, file doesn't come up? Help | Excel Worksheet Functions |