Cell Text

[Guest]

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!

 

[Guest]

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

 

[Guest]

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

 

[Guest]

Thank you. Worked perfectly!

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

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!

 

[Guest]

Thank you. Worked perfectly!

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