G Guest Nov 23, 2005 #1 How do I show -ve numbers with minus sign; +ve numbers with plus sign and 0 without any sign on Excel?
How do I show -ve numbers with minus sign; +ve numbers with plus sign and 0 without any sign on Excel?
R Rowan Drummond Nov 23, 2005 #2 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
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
