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
 
Back
Top