This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I'm on Windows 7, using Office 2010. I have an Excel spreadsheet wherein I frequently use the character strings (R) and (C). These character strings automatically get converted to the Registered symbol (R in a circle) and the Copyright symbol (C in a circle). I can override this conversion by typing ( R) or ( C), so that there is a space between the opening parenthesis and the letter. Then, I can position the cursor on the letter and press Backspace to get rid of the inserted space, and the conversion does not happen. This is a bothersome was to handle this data entry task. Is there any way I can turn off this automatic conversion?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Hi,
Because it is set in AutoCorrect. To remove it, go to Fle Tab | Options | Proofing | Click "Auto Correct Options..." button | click the (c) then Delete, same as the (r).
Hope it helps,
~jaeson
Answer accepted by question author
I'm on Windows 7, using Office 2010. I have an Excel spreadsheet wherein I frequently use the character strings (R) and (C). These character strings automatically get converted to the Registered symbol (R in a circle) and the Copyright symbol (C in a circle). I can override this conversion by typing ( R) or ( C), so that there is a space between the opening parenthesis and the letter. Then, I can position the cursor on the letter and press Backspace to get rid of the inserted space, and the conversion does not happen. This is a bothersome was to handle this data entry task. Is there any way I can turn off this automatic conversion?
Hi,
They are autocorrect options so
File|Options|Proofing|Auto-Correct options
Enter (R) in the replace box and then click delete. Repeat for (C)
Note this is Global and affects all Office products.
Welcome! Please mark Answered in our response. For the thread will move to Answered queue.
BTW, if you are frequently using (R)/(C), you can set a key to hit to show (R)/(C), like “[“ to (R) and “]” to (C), this also works in Auto Correct option.
Cheers!
~jaeson
Thank you very much for your response. Between your response and Jaeson's, I was able to make AutoCorrect work the way I would like it to work.
Thank you very much for your reply. Interestingly, my list did not show (r), but I deleted (c) and added (c) and (r) to convert to (C) and (R), and all is working as I would like it to.