entering the string CNA in a cell is changed to CAN

  • Thread starter Thread starter david bixby
  • Start date Start date
D

david bixby

I'm using Excel to store a few string oriented translation
lists. When I type the string "CNA" into the list, Excel
is automatically changing it to "CAN". This is happening
in Excel 97 and Excel 2000.

I've tried the normal string delimiter ' and changing the
cell type from general to text, and it still keeps
happening. I've also examined check the options.

Any ideas about why this is happening?
 
David,

This is an autocorrect issue!
Fix:
Tools -> AutoCorrect
Find the entry
Replace: cna With: can
Delete it.

Will affect all office products (I think...)

Dan E
 
My guess is the Autocorrect feature of Excel. Under Help see
Autocorrect > Delete an AutoCorrect entry. Get rid of CNA.

HTH
Paul
 
Hi David,
The issue you face is use to autocorrect is turned on. To
fix this click tools -> Autocorrect option. In the Auto
correct folder. "Uncheck" the "Replace text as you type"
and click "OK" then in the sheet if you type "CNA" then
it will remain as "CNA". Hope this help.
Regards
 
Back
Top