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

S

shirley

How do I show -ve numbers with minus sign; +ve numbers with plus sign and 0
without any sign on Excel?
 
R

Rowan Drummond

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
 
Top