-ve no with -1; positive with sign+ and 0 no sign? Tks.
Select the cells you want to apply this to. From the menus select
FormatCells. 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
shirley wrote:
How do I show -ve numbers with minus sign; +ve numbers with plus sign and 0
without any sign on Excel?
|