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

G

Guest

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)
 
G

Guest

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)
 
G

Guest

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)).
 

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

Top