Cell Text

O

orlandobroker

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!
 
E

Elkar

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
 
R

Ron Coderre

Try this:

<tools><options><Spelling tab>
Click the [Autocorrect options] button

Remove "cna" from the "replace list"

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
O

orlandobroker

Thank you. Worked perfectly!

Ron Coderre said:
Try this:

<tools><options><Spelling tab>
Click the [Autocorrect options] button

Remove "cna" from the "replace list"

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


orlandobroker said:
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!
Click to expand...
Click to expand...
 
O

orlandobroker

Thank you. Worked perfectly!

Elkar said:
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
Click to expand...
 
Top