In this article, we are going to show you 3 methods of how to put a plus sign in Excel without a formula. We have taken a dataset consisting of employee information and it has 3 columns: Name, Department, and Phone.
Usage of Plus Sign in Excel
Mostly, there are two scenarios where we may need to add a Plus (+) sign in Excel. The first one is for Phone Numbers. As globalization is happening at a rapid pace, many organizations note their employee’s contact numbers by adding Country Codes. The second case can be for price fluctuations. If we want to show price or any other number changes using the plus sign for increase then we may want to add a plus sign. Although we can use Conditional Formatting for this purpose, it is great to know more than one method for all tasks.
However, Excel does not allow this by default, hence, we’ll get errors whenever we try to input it manually. Therefore, we look for ways to put plus signs in Excel. Now there are a lot of ways to put a plus sign in Excel. In this article, we will show the steps of how to do it without using a formula.
How to Put a Plus Sign in Excel without Formula: 3 Easy Methods
1. Implementing Custom Format Feature to Put a Plus Sign in Excel
For the first method, we will use Custom Format Cells to put a plus sign in Excel without a formula.
- Select range D5:D10 and press CTRL + 1.
This will bring up the Format Cells dialog box.
- select Custom from the Category.
- Then, input +0 inside the Type: box and press OK.
After that, it will add a plus sign in Excel.
- Now, if you have texts, then you need to input +@ in the Text: box. For example, if our text was 1-240-831-0248 then this Custom Format would add a plus sign as +1-240-831-0248.
2. Put a Plus Sign in Excel by Using Single Quote
For the second method, we will use Single Quote to put the plus sign in Excel. This Single Quote or Apostrophe (‘) will treat our value as a text. Here, we have changed the phone number format slightly by adding a dash.
- Double-click on cell D5 and add a plus sign with Apostrhope (‘+). Alternatively, you can click on cell D5 and click again on the formula bar to add this.
- Then, press ENTER.
Thus, it’ll insert a plus sign in Excel without any formula.
Then, repeat this for other cells. However, If you have a large amount of data, you should follow the first method.
Read More: How to Insert Square Root Symbol in Excel
3. Formatting as Text to Put a Plus Sign in Excel
For the last method, we will format our values as Text from the Ribbon toolbar. This method is similar in nature to the second method, but we will need to type only the plus sign in this case.
- Select range D5:D10.
- From the Home tab >> Number Format >> Select Text.
Now, our values will be formatted as Text.
- Then, double-click on cell D5 and add a plus sign.
- Finally, repeat this for the rest of the cells.
Thus, we have shown you yet another method of putting a plus sign in Excel without a formula.
We have included practice datasets for each method in the Excel file.
Download Practice Workbook
We’ve shown you 3 quick methods of how to put a plus sign in Excel without a formula. If you face any problems, feel free to comment below. Thanks for reading, keep excelling!
- How to Add Symbol Before a Number in Excel
- How to Insert Degree Symbol in Excel
- How to Insert Sigma Symbol in Excel
- How to Type Math Symbols in Excel
- How to Type Diameter Symbol in Excel
- How to Use Multiply Sign in Excel
- How to Insert Less Than or Equal to Symbol in Excel
- How to Insert Greater Than or Equal to Symbol in Excel