(C) - changes to the copyright symbol

[Jim Schmidt]

Does anyone know of a permanent fix (cell formatting or otherwise) to make (C) not appear as the copyright symbol © when entered into a cell? A temporary fix is to enter ('C') or ( C ), then tab out of cell and then delete the spaces or single quotes.

 

[Chip Pearson]

Jim,

Go to the Tools menu, choose AutoCorrect Options, and delete the
entry that changes (c) to the copyright symbol. It is typically
the first entry in the list.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



message

Does anyone know of a permanent fix (cell formatting or

otherwise) to make (C) not appear as the copyright symbol © when
entered into a cell? A temporary fix is to enter ('C') or ( C ),
then tab out of cell and then delete the spaces or single quotes.

 

[Guest]

Hi Jim,

Not exactly permanent but will work one workbook at a
time. Use a helper cell. As you state, enter ('C') in
the helper cell, then delete the single quotes. Then just
call it to where you want it.

Don

-----Original Message-----
Does anyone know of a permanent fix (cell formatting or

otherwise) to make (C) not appear as the copyright symbol
© when entered into a cell? A temporary fix is to enter
('C') or ( C ), then tab out of cell and then delete the
spaces or single quotes.

 

[Guest]

Hi Jim,

Not exactly permanent but will work one workbook at a
time. Use a helper cell. As you state, enter ('C') in
the helper cell, then delete the single quotes. Then just
call it to where you want it.

Don

-----Original Message-----
Does anyone know of a permanent fix (cell formatting or

otherwise) to make (C) not appear as the copyright symbol
© when entered into a cell? A temporary fix is to enter
('C') or ( C ), then tab out of cell and then delete the
spaces or single quotes.

 

[Llobid]

Hi...

Chip's solution is permanent