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 ®?