Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you make a "cents" sign on the keyboard? Susan at work Excel Discussion (Misc queries) 2 September 18th 08 06:29 PM
How to make a cents symbol in Excel 2007 Scott Salt Lake Excel Discussion (Misc queries) 5 July 3rd 08 03:12 PM
how can i change dollar sign to rupee sign in sales invoice vishal kohli Excel Discussion (Misc queries) 3 May 10th 07 02:06 PM
My Excel totals are always 1 or 2 cents too low. Any ideas? Andyb Excel Discussion (Misc queries) 2 November 17th 06 08:59 PM
Rounding to nearest 5 cents in excel usnst Excel Worksheet Functions 3 January 17th 06 12:27 AM


All times are GMT +1. The time now is 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"