wont accept text

[Ron Patterson]

Excel version 2002

I am keep typing ACN (a stock symbol but pure text) into a cell and it
displays CAN.
This happens anywhere on the page and even if I type ACN into a comment thne
CAN appears
I keep clearing and reformatting the cell to no avail
This also occurs if I open a new file and type ACN anywhere in it.

This is the strangest thing I have ever seen .

 

[Claus Busch]

Hi Ron,

Am Fri, 20 Dec 2013 10:56:54 -0800 schrieb Ron Patterson:

I am keep typing ACN (a stock symbol but pure text) into a cell and it
displays CAN.
This happens anywhere on the page and even if I type ACN into a comment thne
CAN appears
I keep clearing and reformatting the cell to no avail
This also occurs if I open a new file and type ACN anywhere in it.

look into the Options => Proofing => Auto-Correct-Options if there is a
rule that changes ACN to CAN

Regards
Claus B.

 

[Ron Patterson]

WOW - good on you Claus - a bit of a different path than you showed me
but got me thinking - I found it under Tools >

Auto Correct Options - it was listed there for some unknown reason to
always change ACN to CAN. I deleted it.

I didn't even know this stuff existed in the program.

Well done !!

Ron

 

[Claus Busch]

Hi Ron,

Am Fri, 20 Dec 2013 20:16:08 -0800 schrieb Ron Patterson:

I found it under Tools >
Auto Correct Options

sorry, I did not consider your Excel version and showed you the path for
xl2007 or later


Regards
Claus B.