(R) not ®

October 21, 2008 7:03 AM

Whenever I type (R) in MS excel, it automatically makes the registered trademark sign ®. How do I turn this off?

This is driving me nuts. I not having luck with MS help or google. The IT guys didn't know how to fix this either. My document is currently filled with (R )'s instead. aaaeeuuurrrgh.

posted by spec80 to computers & internet (4 comments total)

Tools - AutoCorrect Options...

Highlight the (r) ® row under "Replace: With" and click Delete. Or uncheck the "Replace text as you type" box if you want to disable all such replacements.

(This is on Excel 2003, don't know if it's in the same place on other versions.)
posted by DevilsAdvocate at 7:10 AM on October 21, 2008

This drives me nuts too (when typing (c) and getting the copyright symbol) - but I find one solution is to type it in and then do a ctrl+z to undo.
posted by panboi at 7:15 AM on October 21, 2008

Office 2007
after it changes, hit backspace and a wizzard appears and you can choose change back to (r) or stop automatically correcting (r). It will also let you go Autocorrect options if you want to take DevilsAdvocates suggestion.
posted by Ferrari328 at 7:16 AM on October 21, 2008

THANK YOU.
posted by spec80 at 7:19 AM on October 21, 2008