-ve no with -1; positive with sign+ and 0 no sign? Tks.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I show -ve numbers with minus sign; +ve numbers with plus sign and 0
without any sign on Excel?
 
Select the cells you want to apply this to. From the menus select
Format>Cells. Select the Number tab and then in the Category box Select
Custom. In the Type box enter:
+#,##0;-#,##0;0
Click on OK

Hope this helps
Rowan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

changing signs 1
Force "+" sign 2
Negative numbers 5
Formula for counting and dividing 2
How can I ge tmy sum to show the + sign for positive sums? 4
How do I prefix a worksheet of numbers with a Minus (-) Sign 4
Comparing two columns , and giving comparison results in a third. 5
Custom format num > 0 with a "+" 4

Back
Top