Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |