How can I type (R) & not get the registered symbol (r in a circle)

Y

Yeller

edI recently upgraded from Office97 to Office 2003. In Excel 97 when I typed
(R) that's what I got. Now, in Excel 2003, when I type (R) it automatically
gets converted to the register symbol (the letter r in a cicrle). I have a
spreadsheet on movies I've taped and always list the film's rating, i.e.,
(G), (PG), (PG13), (R), etc.
 
G

garfield-n-odie

In Excel, click on Tools | AutoCorrect Options | AutoCorrect tab, and
delete the AutoCorrect entry for (r).
 
B

Bob Phillips

Go to menu Tools>Autocorrect. You should see an entry for (r) in there,
juste delete it.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
V

vishu

You can also try: "R)" and then "("

Bob Phillips said:
Go to menu Tools>Autocorrect. You should see an entry for (r) in there,
juste delete it.

--

HTH

RP
(remove nothere from the email address if mailing direct)
Click to expand...
 
C

CyberTaz

Accurate information from all, but deleting AutoCorrect items can limit you
if you ever want to use the items you delete from AutoCorrect.

You can also simply UnDo (Ctrl+z) once the replacement is triggered to
revert to the data as typed. That technique allows the AutoCorrect item to be
available when needed.

Hope this is useful |:>)
 
D

Debra Dalgleish

Or, instead of deleting the AutoCorrect entry for (r), you could change
it to (r)).
 
Top