Cent Symbol

[Sully38]

In Excel 97 is it possible to insert a cent symbol and not the dollar sign???

 

[Tom Urtis]

Format the cell as something other than currency to avoid the automatic dollar sign in front of a number. Where you want the "¢" cents symbol to appear in the cell, do so by pressing the Alt key and while that's pressed, enter the numerals 0162, release the Alt key, and hit Enter. Any help?

 

[Sully38]

You are DA MAN!!! Works like a champ!!!!

Curious though I tried it on my version Excel (2002) and it didn't work, what did they change?

 

[Zack Barresse]

Book3.xls
	E	F	G	H
7
Sheet7

e7:
F2 (edit) -> Alt + 0162.
f7:
=char(162)

works for me in xp

hth

 

[Sully38]

Actually this is pretty interesting as I only get it to work if I type the 0162 in with my "keypad" to the left side of the keyboard, not if I use the numbers across the top of keyboard..Very Interesting!!!

 

[Zack Barresse]

yes, must be a keypad entry.

 

[Sully38]

Back to kindy-garden for me.. imeant "right side" of keyboard

 

[Zack Barresse]

we won't hold it against you . . . just this once! don't let it happen again though! :wink: