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

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

Depending on your needs, you may instead choose to unclick the entire
"Replace text as you type" option. If you work with stock symbols a lot,
this could happen again to you, without you even noticing. That could be a
Bad Thing.

As for the dollar/percent sign thing, it sounds like once you entered a
dollar sign Excel decided it was a currency value; to correct it, go to the
formatting options and change it to a percent value. That's in Options,
Cells, in the Number tab.

--- "Mike H" wrote:
Look in Tools|Autocorrect options, type ACN in the replace box and delete the autocorrect option.

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