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

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.

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

Yeller wrote:

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

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)


"Yeller" <[email protected]> wrote in message
news:[email protected]...
> 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.

Go to Tool, Auto Correct Options and delet (r) from the list.

"Yeller" wrote:

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

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

"Bob Phillips" wrote:

> 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)
>
>
> "Yeller" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>

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

"Yeller" wrote:

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

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

CyberTaz wrote:
> 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 |:>)
>
> "Yeller" wrote:
>
>
>>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.
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html