Table of Contents
When you type
(r) (c or r enclosed in parentheses) in any Microsoft Office product like Excel or Word it gets automatically changed to Registered symbol
® (R in a circle) and the Copyright symbol
© (C in a circle).
This is due to AutoCorrect feature build into Office products.
AutoCorrect has been created to correct typos, capitalization errors, and misspelled words, as well as automatically insert symbols and other pieces of text.
By default, AutoCorrect uses a standard list of typical misspellings and symbols, but you can modify the entries in this list.
Most of the times is very helpful but in some situations it can be very annoying. This is the example when it is annoying.
There are two ways of dealing with it. First one is fast and is perfect when you need to use it only few times. Second one is permanent and involves configuring the default AutoCorrect list of items it uses so that it will not replace (c) or (r) to © or ® symbols.
Single instance reversal
Type in text as usual (c). AutoCorrect will change it to ©
Press CTRL+Z. This will undo AutoCorrect change and bring back (c) text.
AutoCorrect settings are global. Changes done in one program like Word affect all installed Microsoft Office products Excel, Access etc.
For example if you don't want to replace (c) with © in Word, but want it to happen in Excel, you have to think which is more important to you.
Based on that you can decide which item you will have to insert manually: (c) in Single instance reversal from this article, or © when when you decide to use Permanent solution.
Go to File tab
Click Options at the bottom-left
In options window go to Proofing and in AutoCorrect options click AutoCorrect Options...
In AutoCorrect tab there is a list of items which are replaced by AutoCorrect. Select one you want to delete, for example if you want to stop (c) conversion to © then click (c) line and click Delete below the list.
When done, click OK button.