| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
-ve no with -1; positive with sign+ and 0 no sign? Tks.
How do I show -ve numbers with minus sign; +ve numbers with plus sign and 0
without any sign on Excel? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
-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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hot to get + sign on positive nos | Excel Discussion (Misc queries) | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| FORMULA TO ADD POSITIVE AND NEGATIVE NUMBERS, REGARDLESS OF SIGN | Excel Discussion (Misc queries) | |||
| Automatically put negative sign in cells with positive numeric dat | Excel Discussion (Misc queries) | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
Linear Mode
