J Jake Feb 11, 2009 #1 when I type (c) in excell it returns a c with a circle around, can anyone help?
M muddan madhu Feb 11, 2009 #2 That's auto correction , if u want to disable that, then go to tools | auto correction option | uncheck replace text as you type | ok
That's auto correction , if u want to disable that, then go to tools | auto correction option | uncheck replace text as you type | ok
M Mike H Feb 11, 2009 #3 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
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
B Bob Umlas, Excel MVP Feb 11, 2009 #4 Just to be different: You can type ="(c"&")" Mike H said: 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 Click to expand...
Just to be different: You can type ="(c"&")" Mike H said: 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 Click to expand...
B Bernard Liengme Feb 11, 2009 #5 And when Excel converts (c) to © you can use CTRL+Z to undo that action best wishes
R Rick Rothstein Feb 11, 2009 #6 Hmm! The last action taken is the auto-correct, so Undo (Ctrl+Z) undoes it.... nice tip Bernard.
R Rick Rothstein Feb 12, 2009 #7 Type an apostrophe first '(c) This can be used to prevent auto changing to dates e.g '1/6 etc. Click to expand... Not if the (c) is in the middle of the text.
Type an apostrophe first '(c) This can be used to prevent auto changing to dates e.g '1/6 etc. Click to expand... Not if the (c) is in the middle of the text.
D David McRitchie Feb 12, 2009 #8 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
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
R Rick Rothstein Feb 12, 2009 #9 Actually, not if the (c) is anywhere in the text... the apostrophe won't stop the auto-correct from "correcting" the entry.
Actually, not if the (c) is anywhere in the text... the apostrophe won't stop the auto-correct from "correcting" the entry.
