when I type (c) in excell it returns a c with a circle around, can anyone help?

That's auto correction , if u want to disable that, then
go to tools | auto correction option | uncheck replace text as you
type | ok


On Feb 11, 11:39*pm, Jake wrote:
when I type (c) in excell it returns a c with a circle around, can anyone help?

Hi,

Auto correct is a useful tool and you can delete individual entries that you
don't want.

Tools|autocorrect options and type c in the replace box an then delete the
entry.

Mike

"Jake" wrote:

when I type (c) in excell it returns a c with a circle around, can anyone help?

Just to be different: You can type ="(c"&")"

"Mike H" wrote:

Hi,

Auto correct is a useful tool and you can delete individual entries that you
don't want.

Tools|autocorrect options and type c in the replace box an then delete the
entry.

Mike

"Jake" wrote:

when I type (c) in excell it returns a c with a circle around, can anyone help?

And when Excel converts (c) to © you can use CTRL+Z to undo that action
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mike H" wrote in message
...
Hi,

Auto correct is a useful tool and you can delete individual entries that
you
don't want.

Tools|autocorrect options and type c in the replace box an then delete the
entry.

Mike

"Jake" wrote:

when I type (c) in excell it returns a c with a circle around, can anyone
help?

Hmm! The last action taken is the auto-correct, so Undo (Ctrl+Z) undoes
it.... nice tip Bernard.

--
Rick (MVP - Excel)


"Bernard Liengme" wrote in message
...
And when Excel converts (c) to © you can use CTRL+Z to undo that action
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mike H" wrote in message
...
Hi,

Auto correct is a useful tool and you can delete individual entries that
you
don't want.

Tools|autocorrect options and type c in the replace box an then delete
the
entry.

Mike

"Jake" wrote:

when I type (c) in excell it returns a c with a circle around, can
anyone help?

Type an apostrophe first '(c)
This can be used to prevent auto changing to dates e.g '1/6 etc.


--
mdmackillop
------------------------------------------------------------------------
mdmackillop's Profile: http://www.thecodecage.com/forumz/member.php?userid=113
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=62584

Type an apostrophe first '(c)
This can be used to prevent auto changing to dates e.g '1/6 etc.

Not if the (c) is in the middle of the text.

--
Rick (MVP - Excel)

Since it is not so easy to remember to use alt+0169 on a desktop, or
Fn+Alt+0169 on a laptop, you might wish to leave it, and use Ctrl+Z
to immediately change it back as soon as typed and changes on screen
when you don't want to the use the copyright symbol, ©, as replacement for (c).

"Mike H" wrote
Auto correct is a useful tool and you can delete individual entries that you
don't want.

Tools|autocorrect options and type c in the replace box an then delete the
entry.

"Jake" wrote:
when I type (c) in excell it returns a c with a circle around, can anyone help?

Actually, not if the (c) is anywhere in the text... the apostrophe won't
stop the auto-correct from "correcting" the entry.

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
Type an apostrophe first '(c)
This can be used to prevent auto changing to dates e.g '1/6 etc.

Not if the (c) is in the middle of the text.

--
Rick (MVP - Excel)