cell input change
 

whenever I type CNA in a cell, it automatically changes it to CAN.
Unfortunately, CNA is a product code commonly use. I have to copy an imported
text to input CNA in a cell. I've turned off autofill, but it doesn't help.

cell input change
 

Excel is trying to "help" you:

Tools Spelling AutoCorrect Options AutoCorrect

scroll down and remove the correction.
--
Gary''s Student
gsnu200711

cell input change
 

Hi,

Microsoft 2003

1. On the Tools menu, click Autocorrect options.
The AutoCorrect dialog appears.
2. Click the Autocorrect Tab.
3. In the Replace Text box, Type CAN
4. In the With Text box, Type CAN
5. Click OK
-or-
1. On the Tools menu, click Autocorrect options.
The AutoCorrect dialog appears.
2. Click the Autocorrect Tab.
3. Click the scroll bar to identify the letter CNA.
Click that Autocorrect entry.
4. Click the Delete button.
Now whenever you enter CNA, the letters will not replace to CAN.

Challa Prabhu

"dciufo" wrote:

whenever I type CNA in a cell, it automatically changes it to CAN.
Unfortunately, CNA is a product code commonly use. I have to copy an imported
text to input CNA in a cell. I've turned off autofill, but it doesn't help.