Hi,

Look in

Tools|Autocorrect options

type ACN in the replace box and delete the autocorrect option.

Mike

"stevemalee" wrote:

In listing NYSE stock symbols, in a column, the stock symbol ACN is
automatically changed to CAN by Excel.-- this is not a correct symbol.

Have tried every thing by right clicking to clear cell, and the change
always happens.

Could there be a formula in the cell which I cannot find?

This happens both in XP and Vista Excel version 2003.

And also, inserting a dollar sign accidentally in a cell which is incorrect,
the correct sign should have been the percentage sign. Cannot correct the
error to remove the dollar sign.
--
stevemalee