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

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.
 
A

Aladin Akyurek

Either disable the AutoCorrect option or remove the relevant entry fro
AutoCorrect.
 
A

Arvi Laanemets

Hi

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

Arvi Laanemets
 
B

Bob Phillips

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)
 
N

Niek Otten

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

Last Modified By in a cell by user 3
how do I stop re-calculated fields in excel from going "black" 1
How do I customize hotkeys for excel 2007? 1
How do I stop Excel from copying date format from cell above? 2
Stop next cell being selected on Enter 2
Can I automatically have a space after the content in an Excel cel 2
How do I add typing instructions to an Excel cell? 4
How do I stop the cell from becoming a drop down box when editing 3

Top