How to display plus or minus sign in excel(Show + or - before integers or decimals) Select B2:B8, press Ctrl + 1, open the "Format Cells" dialog box, select the "Number" tab, click "Custom" on the left side of the dialog box, and copy the format +0 -0 into the textbox under "Type", click "OK", then + will be displayed before positive numbers, and - will be displayed before negative numbers the operation steps are shown in Figure 1:Ģ. (I) A plus or minus sign is displayed before the number(greater than 0, + is displayed less than 0, - is displayed) I, Excel displays plus(+) or minus(-) or positive and negative sign(±) before number You can also convert negative numbers to positive numbers or vice versa in Excel. In Excel, positive and negative numbers are marked with different colors or both with color and parentheses, you can use custom format of cell, but the former can also use conditional format.
If a negative and positive sign(±) is required before the number, there are two input methods, one is to use the shortcut key, and the other is to insert from the Excel symbol. If you want to display positive signs, you need to customize the format of cell. Only negative signs are displayed before numbers, and positive signs are not displayed by default in Excel.
0 kommentar(er)
