CNA turns into CAN!

C

claytorm

Hi

When I enter "CNA" in cell, it turns it into "CAN"!

I've checked the cell is formatted as text, which should display th
text exactly as entered. I've also tried it in other cells in th
sheet.

???

Berti
 
A

AlfD

Hi!

Have a look at Tools > autocorrect options.

You will find cna in the list of things which Excel "corrects".
You can delete it or turn off autocorrect.

Al
 

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

Cell Text 4
How do I stop CNA typed in an Excel cell becoming CAN by itself? 5
conditional format cells by date 2
Imported formatting affecting advanced filter? 3
Date formatting error 1
entering the string CNA in a cell is changed to CAN 5
How do you paste a list of bulleted text from a word doc. into exc 2
Getting ### (hash) symbols in text cell instead of text 2

Top