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”.
Download Practice Workbook
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 the 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.
3 Ways to Put a Plus Sign in Excel without Formula
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.
- Firstly, select the cell range D5:D10.
- Secondly, press CTRL + 1.
This will bring up the Format Cells dialog box.
- Thirdly, select Custom from the Category.
- Then, input “+0” inside the “Type:” box.
- Finally, press OK.
After that, it will add a Plus sign in Excel.
Now, if you have texts, then you need to input “[email protected]” 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”.
- Insert Less Than or Equal to Symbol in Excel (5 Quick Methods)
- How to Type Minus Sign in Excel Without Formula (6 Simple Methods)
- Put 0 in Excel in Front of Numbers (5 Handy Methods)
- How to Insert Dollar Sign in Excel Formula (3 Handy Methods)
- Excel Formula Symbols Cheat Sheet (13 Cool Tips)
2. Put a Plus Sign in Excel by Using Single Quote
For the second method, we will use Single Quote to put 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.
- First, Double Click on cell D5 and add 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 put 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.
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.
- First, select the cell range D5:D10.
- Secondly, 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.
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!
- Insert Degree Symbol in Excel (6 Suitable Methods)
- How to Insert Symbol in Excel Header (4 Ideal Methods)
- Insert Symbol in Excel Footer (3 Effective Ways)
- How to Type Math Symbols in Excel (3 Easy Methods)
- Put Equal Sign in Excel without Formula (4 Easy Ways)
- How to Insert Greater Than or Equal to Symbol in Excel (5 Quick Methods)
- Insert square root symbol in Excel (7 easy ways)