Where is the cents sign in Excel

I

ImBlonde

I appreciate all your help. I mlay need to know it for Word also if you
would be so kind.

Thank You
 
F

FSt1

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
 
J

John

Hi FSt1
I don't know if were talking about the same thing but for me the cent sign "¢"
is Alt>0162
Please correct me if i'm wrong.
Regards
John
 
J

JLatham

Both answers are correct.



John said:
Hi FSt1
I don't know if were talking about the same thing but for me the cent sign "¢"
is Alt>0162
Please correct me if i'm wrong.
Regards
John



.
 
J

JLatham

To add a little more:
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.
 
J

John

Thank you JLatham for your insight, I would of thought they would have different
names.
Regards
John
JLatham said:
To add a little more:
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 said:
Hi FSt1
I don't know if were talking about the same thing but for me the cent sign
"¢"
is Alt>0162
Please correct me if i'm wrong.
Regards
John



.
 
J

JLatham

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 said:
Thank you JLatham for your insight, I would of thought they would have different
names.
Regards
John
JLatham said:
To add a little more:
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 said:
Hi FSt1
I don't know if were talking about the same thing but for me the cent sign
"¢"
is Alt>0162
Please correct me if i'm wrong.
Regards
John

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

:

I appreciate all your help. I mlay need to know it for Word also if you
would be so kind.

Thank You

.

.
 
Top