How do I stop CNA typed in an Excel cell becoming CAN by itself?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On a spreadsheet listing my shares, one is Centrica plc, EPIC code CNA. I
type CNA in the cell for the EPIC code, but when I hit Enter it becomes CAN.
It seems to do this in all cells, but if I enter xCNA, press Enter, then
edit it to remove the x, it stays as CNA.
 
Either disable the AutoCorrect option or remove the relevant entry fro
AutoCorrect.
 
Hi

Turn Autocorrect off. Or delete the CNA -> CAN entry from autocorrect list.

Arvi Laanemets
 
Go in to Tools>Autocorrect, and you should find an entry there. Just delete
it.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Tools>AutoCorrect Options, remove the cna entry

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I can't type whole numbers in excel they get converted to .000 1
Dictionary or Spelling in Excel 2003 3
entering the string CNA in a cell is changed to CAN 5
"CNA" become "CAN", how can I fix this ? 3
How to stop CNA from being auto changed to CAN? 1
Last Modified By in a cell by user 3
Text Color Changes By Itself 3
Excel bug? cell comments become uneditable 2

Back
Top