| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Text
Thank you. Worked perfectly!
"Elkar" wrote: Tools -- Options -- Spelling Tab Click the "AutoCorrect" button. Uncheck the box called "Replace text as you type" OR If you don't want to completely disable AutoCorrect, you can just remove that one paticular word from the AutoCorrect List. Scroll down until you find CNA, select it, then click the "Delete" button. OR If you think you may still want CNA in the AutoCorrect List, you can override the AutoCorrect feature by using a formula. ="C"&"N"&"A" This will display CNA in the cell, and will not be AutoCorrected. HTH, Elkar "orlandobroker" wrote: How can I type "CNA" into a cell in MS Excel 2002 without it changing my text to "CAN"? I have even tried typing in 'CNA in the cell...and it still changes it. Even if I type the words "Policy CNA"...it still changes the CNA TO CAN. Is this an auto-correct feature in MS and is there a way to disable the auto-correct? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Capacity - text | Excel Discussion (Misc queries) | |||
| How can I make an excel cell equal to the value of a frame object text box | Excel Worksheet Functions | |||
| Cell text based on 4 condition test | Excel Worksheet Functions | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Threaded Mode
