This post will guide you how to add plus sign next to positive numbers in Excel. How do I add a plus sign before positive numbers in multiple cells with format cells feature in Excel.
Add Plus sign before Positive Numbers
If you want to add the plus sign before the positive numbers in cells, you may be think that typing the plus sign next to one cell that contain positive number, you should notice that the plus sign would not be displayed. So How to do it. You can use the format cell feature to convert the selected cells to add plus sign before the positive numbers. Here are the steps:
#1 select the range of cells that you want to add plus sign.
#2 right click on it, and select Format Cells from the popup menu list. And the Format Cells dialog will open.
#3 select Custom category under the Category list box, and then type the format code +0;-0;0 into the type text box, and click Ok button.
#4 you would notice that all positive numbers in the selected range have been added the plus signs.