Cell Text
 

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!

Cell Text
 

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!

Cell Text
 

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

Cell Text
 

Thank you. Worked perfectly!

"Ron Coderre" wrote:

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

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!