How do I stop Excel converting (R) to ®?
 

I am trying to replicate a document that has (R) but every time I type it in
I get ®. Is there a way to stop Excel converting (R) to ®?

How do I stop Excel converting (R) to ®?
 

Hi,

Tools|Auto correct and delete the auto correct option for (R)

However, I think this is a global office setting and not limited to Excel so
this may be a problem in (say) Word.

Mike

"NHS Paul" wrote:

I am trying to replicate a document that has (R) but every time I type it in
I get ®. Is there a way to stop Excel converting (R) to ®?

How do I stop Excel converting (R) to ®?
 

ToolsAutocorrect Options.

Delete the entry for ® correction.


Gord Dibben MS Excel MVP

On Thu, 5 Jul 2007 02:24:02 -0700, NHS Paul <NHS
wrote:

I am trying to replicate a document that has (R) but every time I type it in
I get ®. Is there a way to stop Excel converting (R) to ®?

How do I stop Excel converting (R) to ®?
 

Paul,

You can selectively stop it from making the change with Undo. Unfortunately, at least in
Excel 2003, if the (R) is the last thing in the cell, you don't get the chance -- you have
to do the Undo before you've pressed Enter.

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"NHS Paul" <NHS wrote in message
...
I am trying to replicate a document that has (R) but every time I type it in
I get ®. Is there a way to stop Excel converting (R) to ®?