Share via

Displaying a positive number on a spreadsheet

Anonymous
2022-10-26T11:52:38+00:00

How do I display a '+' (plus sign) for positive numbers and a '-' (negative sign) for negative numbers in Excel?

Microsoft 365 and Office | Excel | For home | Windows

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. Anonymous
    2022-10-26T12:22:50+00:00

    Use in cell-properties - Custom:

    • #,###.00;- #,###.00;0.00

    Quotes are not necessary !

    2 people found this answer helpful.
    0 comments

Answer accepted by question author

  1. Anonymous
    2022-10-26T12:40:58+00:00

    Hello Richard,

    Thank you for posting your question in our community, if you are trying to display the + or - symbol alone when numbers are positive or negative then you can use the formula below:

    =IF(C8<0,"-",IF(C8>0,"+",0))

    Best Regards, Asher

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest