(R) ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Laurence Smith - 10 Dec 2007 14:03 GMT

Hi,
I am finding that I cannot place (R), meaning a capital R between two
parentheses in to a cell. Excel always replaces that with a smaller
capital R in a circle.
What's the trick to getting the (R) to show up?

TIA

Signature

Larry Smith

"In this country anyone can grow up to be President.
That's the risk you take."
Adlai Stevenson

Reply to this Message

Bernard Liengme - 10 Dec 2007 14:12 GMT

This is an AutoCorrect feature - Excel kindly giving you the Registered
Trademark symbol. Use Tools | AutoCorrect Options; on the AutoCorrect tab
near the top of the list you will probably see (c), (r) and (tm). Select the
ones you do not want and press the Delete button on the dialog.
The alternative is just after Excel makes the conversion, press control+Z
(undo)
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> Hi,
> I am finding that I cannot place (R), meaning a capital R between two
[quoted text clipped - 3 lines]
>
> TIA

Reply to this Message

Laurence Smith - 11 Dec 2007 00:20 GMT

> This is an AutoCorrect feature - Excel kindly giving you the
> Registered Trademark symbol. Use Tools | AutoCorrect Options; on the
> AutoCorrect tab near the top of the list you will probably see (c),
> (r) and (tm). Select the ones you do not want and press the Delete
> button on the dialog. The alternative is just after Excel makes the
> conversion, press control+Z (undo) best wishes

Bernard,

Thanks for the prompt reply.
Of course, you are right. As soon as I made the fix all was fine.

I appreciate the time and expertise.

Signature

Larry Smith

"In this country anyone can grow up to be President.
That's the risk you take."
Adlai Stevenson

Reply to this Message