How do I get rid of the copyright symbol?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ultra_xcyter - 30 Jun 2005 14:29 GMT

I am trying to enter "(c)" into a cell and everytime I do that, Excel
automatically converts it to the copyright symbol, which I don't want.
I've tried formatting the cell to text, general, etc. but that doesn't
work.

Is there a way to enter "(c)" without it automatically being converted
to the copyright symbol?

Thank you in advice for any advice/tips.

Signature

ultra_xcyter

Reply to this Message

swatsp0p - 30 Jun 2005 14:51 GMT

You need to modify the AutoCorrect setting. From Tools>Options

|Spelling, click "Auto Correct Options..."

Scroll down to find the (c) and edit it to [c] and click OK.

now, (c) will remain unchange, and you call the copyright symbol by
entering [c]

Good Luck

Bruce

Signature

swatsp0p

Reply to this Message

doltish - 30 Jun 2005 16:44 GMT

You could also try placing a ' mark before your input. That usuall
tells Excel not to modify what you enter into the cell at all. So '(c
should work. It's a magical thing that somebody taught me a while ag
that has saved me so many headaches since

Reply to this Message

ultra_xcyter - 30 Jun 2005 17:13 GMT

Doltish & Swatsp0p: Both your suggestions worked great! Thank you ver
much for your help. No more headaches for me! Or at least until nex
time

Reply to this Message

swatsp0p - 30 Jun 2005 17:26 GMT

Ultra: I'm glad you found a solution. Thanks for the feedback, it i
always appreciated.

Doltish: I tried your tip, but for me the ' didn't do anything and m
[c] still returned the copyright symbol. Hmmmm..... I don't know...
must be missing something.... I tried changing [c] back to (c) in th
AutoCorrect option to no avail. '(c) still brought up the symbol.

Bruc

--
swatsp0

Reply to this Message

George Nicholson - 30 Jun 2005 18:57 GMT

Alternatively:
-Type (c) + space (entering the space invokes auto-correct and changes
your entry to the copyright symbol)
-Ctrl+Z (undo last action: i.e., the autocorrect. Your entry is
restored.)
-Finally, press Enter

Signature

George Nicholson

Remove 'Junk' from return address.

> Doltish & Swatsp0p: Both your suggestions worked great! Thank you very
> much for your help. No more headaches for me! Or at least until next
> time.

Reply to this Message

swatsp0p - 30 Jun 2005 20:15 GMT

George, I like the CTRL+Z tip. Works great!

Thanks,

Bruc

--
swatsp0

Reply to this Message