Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Go to menu ToolsAutocorrect. You should see an entry for (r) in there,
juste delete it. -- HTH RP (remove nothere from the email address if mailing direct) "Yeller" wrote in message ... 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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
You can also try: "R)" and then "("
"Bob Phillips" wrote: Go to menu ToolsAutocorrect. You should see an entry for (r) in there, juste delete it. -- HTH RP (remove nothere from the email address if mailing direct) "Yeller" wrote in message ... 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. |
#6
|
|||
|
|||
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. |
#7
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to type a minues figure | New Users to Excel | |||
I want to type a text in a cell, but I want that text to represen. | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Custom Type Charts Problem | Excel Worksheet Functions |