How to Add a Plus Sign before Positive Numbers in Excel

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.

add plus sign before positive number1

#2 right click on it, and select Format Cells from the popup menu list. And the Format Cells dialog will open.

add plus sign before positive number2

#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.

add plus sign before positive number3

#4 you would notice that all positive numbers in the selected range have been added the plus signs.

add plus sign before positive number4

 

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar