typing (c) in excell

[Jake]

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

 

[muddan madhu]

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

 

[Mike H]

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

 

[Bob Umlas, Excel MVP]

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

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

 

[Bernard Liengme]

And when Excel converts (c) to © you can use CTRL+Z to undo that action
best wishes

 

[Rick Rothstein]

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

 

[Rick Rothstein]

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.

 

[David McRitchie]

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

 

[Rick Rothstein]

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