ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Where is the cents sign in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/258999-where-cents-sign-excel.html)

ImBlonde

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

FSt1

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


John[_22_]

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



JLatham

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


.


JLatham

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


.


John[_22_]

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


.



JLatham

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

.


.



All times are GMT +1. The time now is 02:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com