| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where is the cents sign in Excel
I appreciate all your help. I mlay need to know it for Word also if you
would be so kind. Thank You |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where is the cents sign in Excel
hi
the cent sign is a special symble. why i don't know. it didn't make into ascii is all i know. Press/hold Alt key then 155 on the numeric keyboard to get a cent sign. regards FSt1 "ImBlonde" wrote: I appreciate all your help. I mlay need to know it for Word also if you would be so kind. Thank You |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where is the cents sign in Excel
Hi FSt1
I don't know if were talking about the same thing but for me the cent sign "¢" is Alt0162 Please correct me if i'm wrong. Regards John "FSt1" wrote in message ... hi the cent sign is a special symble. why i don't know. it didn't make into ascii is all i know. Press/hold Alt key then 155 on the numeric keyboard to get a cent sign. regards FSt1 "ImBlonde" wrote: I appreciate all your help. I mlay need to know it for Word also if you would be so kind. Thank You |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where is the cents sign in Excel
Both answers are correct.
"John" wrote: Hi FSt1 I don't know if were talking about the same thing but for me the cent sign "¢" is Alt0162 Please correct me if i'm wrong. Regards John "FSt1" wrote in message ... hi the cent sign is a special symble. why i don't know. it didn't make into ascii is all i know. Press/hold Alt key then 155 on the numeric keyboard to get a cent sign. regards FSt1 "ImBlonde" wrote: I appreciate all your help. I mlay need to know it for Word also if you would be so kind. Thank You . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where is the cents sign in Excel
To add a little mo
If you type [Alt]+[1] [5] [5] you'll get a cent-symbol, if you type [Alt]+[0] [1] [6] [2] you'll get a cent-symbol, and of course if you use insert symbol form one of the font sets, you get the cent-symbol. The curious part comes when you use =CODE() for the cells you have showing the cent-symbol. It returns 162 for all 3 instances. "John" wrote: Hi FSt1 I don't know if were talking about the same thing but for me the cent sign "¢" is Alt0162 Please correct me if i'm wrong. Regards John "FSt1" wrote in message ... hi the cent sign is a special symble. why i don't know. it didn't make into ascii is all i know. Press/hold Alt key then 155 on the numeric keyboard to get a cent sign. regards FSt1 "ImBlonde" wrote: I appreciate all your help. I mlay need to know it for Word also if you would be so kind. Thank You . |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where is the cents sign in Excel
Thank you JLatham for your insight, I would of thought they would have different
names. Regards John "JLatham" wrote in message ... To add a little mo If you type [Alt]+[1] [5] [5] you'll get a cent-symbol, if you type [Alt]+[0] [1] [6] [2] you'll get a cent-symbol, and of course if you use insert symbol form one of the font sets, you get the cent-symbol. The curious part comes when you use =CODE() for the cells you have showing the cent-symbol. It returns 162 for all 3 instances. "John" wrote: Hi FSt1 I don't know if were talking about the same thing but for me the cent sign "¢" is Alt0162 Please correct me if i'm wrong. Regards John "FSt1" wrote in message ... hi the cent sign is a special symble. why i don't know. it didn't make into ascii is all i know. Press/hold Alt key then 155 on the numeric keyboard to get a cent sign. regards FSt1 "ImBlonde" wrote: I appreciate all your help. I mlay need to know it for Word also if you would be so kind. Thank You . |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where is the cents sign in Excel
I'm not sure if you'd call it insight, just an observation.
If you put in a formula: =CHAR(155) then you get the .gt. symbol ( ) but =CHAR(162) gives you the cent symbol. Go figure. "John" wrote: Thank you JLatham for your insight, I would of thought they would have different names. Regards John "JLatham" wrote in message ... To add a little mo If you type [Alt]+[1] [5] [5] you'll get a cent-symbol, if you type [Alt]+[0] [1] [6] [2] you'll get a cent-symbol, and of course if you use insert symbol form one of the font sets, you get the cent-symbol. The curious part comes when you use =CODE() for the cells you have showing the cent-symbol. It returns 162 for all 3 instances. "John" wrote: Hi FSt1 I don't know if were talking about the same thing but for me the cent sign "¢" is Alt0162 Please correct me if i'm wrong. Regards John "FSt1" wrote in message ... hi the cent sign is a special symble. why i don't know. it didn't make into ascii is all i know. Press/hold Alt key then 155 on the numeric keyboard to get a cent sign. regards FSt1 "ImBlonde" wrote: I appreciate all your help. I mlay need to know it for Word also if you would be so kind. Thank You . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you make a "cents" sign on the keyboard? | Excel Discussion (Misc queries) | |||
| How to make a cents symbol in Excel 2007 | Excel Discussion (Misc queries) | |||
| how can i change dollar sign to rupee sign in sales invoice | Excel Discussion (Misc queries) | |||
| My Excel totals are always 1 or 2 cents too low. Any ideas? | Excel Discussion (Misc queries) | |||
| Rounding to nearest 5 cents in excel | Excel Worksheet Functions | |||
Linear Mode
