Excel is a great management tool that makes it easier to work with documents and large data files. Despite this, there are a few features in excel that may irritate you sometimes. One of these is adding a plus sign before a number.
Microsoft Excel displays the negative numbers with a minus sign while the positive numbers without a sign. So, how exactly can you add a plus sign before a number when dealing with Excel data?
We give you easy steps to follow to add a plus sign in your excel numbers in the post below. Here we go.
Using the custom number format method
You can use this method to create a custom number format or the cell where you want to show a plus sign.
Here are the steps to follow:
1. Open your excel file and select the cells containing the numbers you want to add the plus sign.
2. Right-click on this selection.
3. Click on the Format Cells option to display a dialog box on the given drop-down list.
4. In the displayed Format Cells dialog box, click on the Number tab.
5. On the Category section, click on the Custom option.
6. In the Type panel, type in the following entries: +0;-0; 0
7. Click the OK button.
After doing this, you will notice the positive sign has been added to the positive numbers while every other value remains the same.
Adding a plus sign before a number in a cell would not change the value in that cell. It only changes the way the cell data is displayed. The sign is not there as the actual content of the cell.
You can also copy and paste this formatting to other cells. First, copy the cells that have the custom format and paste only the format in the destination cells.
You can also use the following codes:
- Negative numbers in brackets and positive numbers with a plus sign: +0 ;( 0); 0
- Positive numbers green and negative numbers in red: [Green] +0; [Red]-0; 0
- Positive numbers in a positive sign and negative numbers red: +0; [Red]-0; 0
Adding the plus sign manually before a number
The above custom formatting method is the best way to go if you have large data sets as it is foolproof and works well.
But, in case you are working with a few cells that you need to add a sign before, you can quickly do this manually.
1. In your open excel file, click on the cell you want to add a plus sign in.
2. Add an apostrophe sign first before typing the plus sign.
3. Next, add your number and click the Enter button on your keyboard.
Adding the apostrophe sign will let Excel know to render the cell content as a text rather than translating it into a number such that when you add the plus sign it will remain.
The apostrophe sign will not be visible in the cell even when you print out your data.