Share via

How do I find a cent symbol or sign?

Anonymous
2012-04-18T22:59:25+00:00

I want to use the dollar and cents sign in an Excel Document and don't know how.

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Bob Jones AKA CyberTaz MVP 434.8K Reputation points
    2012-04-19T13:10:08+00:00

    Just a note to Jim's reply...

    Most work involving currency does not use the ¢ symbol. Pennies simply are expressed as decimal fractions of a Dollar. Technically, "Cents" & "Dollars" are separate units of measurements, so for consistency & to facilitate computations you'd need to express $1.00 as 100¢ - doing so would be quite impractical. A Custom Format can be constructed to include the ¢ but that does nothing to convert the value - IOW, what appeared to be 25¢ would still be treated as a whole number of 25 (dollars), not as "one fourth of a dollar".

    If you just want to use the ¢ symbol for appearance purposes without concern for propriety or calculation, the keystroke is Option+4 on most keyboard layouts.

    Regards,

    Bob J.

    3 people found this answer helpful.
    0 comments

6 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-03-26T17:08:41+00:00

    There is nothing marked "Option" on my keyboard.  I have tried Cntrl, Fn, a Windows symbol, and Alt each plus 4 and nothing happens.  What do you mean by "Option"?

    0 comments
  2. Anonymous
    2012-04-19T16:56:38+00:00

    Dear Bob Jones!

    BINGO!   You've answered my question and it works like a charm.  So if I want to put my 2¢ in a document, I am not able to do it.  I'm a housewife, just like the appearance of the ¢ when I'm corresponding or doing a report.  No calculations involved.  THANK YOU. THANK YOU.  THANK YOU.   Roberta Olshansky

    0 comments
  3. Anonymous
    2012-04-19T16:50:38+00:00

    This reply did not answer my question.  I have the cell formatted as text, but where do I find the cent sign (as a text character) to enter into that cell?

    0 comments
  4. Jim G 134K Reputation points MVP Volunteer Moderator
    2012-04-19T02:46:09+00:00

    There are lots of dollar sign formats in the Custom number formats, but there are no cents signs. You can only use a cent sign entered as a text character if a cell is formatted as text, not a number, so you wouldn't be able to use such a value in calculations.

    0 comments