how to type (R) instead of ® in excel?

C

Chip Pearson

Joe,

There are two option. The first is to type (R) and let it convert to ® and
then press CTRL+Z to change it back to (R) and then type the rest of the
cell contents before pressing ENTER. The other option is to go to the Tools
menu, choose "Auto Correct" and remove the (r) item from the list. Note that
this second method will remove the auto correct option for all Office
applications, not just Excel.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
 
M

M Scott

You can type a decimal in front of it first.

..(R) will then display as .(R) then simply edit the cell and delete the
period.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Size of RTF increasing 10x after minor edit 0
How do I stop Excel converting (R) to ®? 3
Wordé¸å–範åœè¢«éŽ–定 1
the add-in Multimap for Microsoft® Outlook® 1
How do I stop Excel from changing (R) to ® 1
How do I prevent (R) from changing to ® 1
type mismatch error in macro in excel 0
număr maxim de fonturi în excel 1

Top