How to Put a Plus Sign in Excel without Formula (3 Easy Methods)

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

Main Dataset of how to put a plus sign in excel without formula


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.

Steps:

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

Format Cells in how to put a plus sign in excel without formula

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

Custom Number Format in how to put a plus sign in excel without formula

Read More: How to Put Sign in Excel Without Formula (5 Ways)


Similar Readings


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.

Steps:

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

Single Quote Method of how to put a plus sign in excel without formula

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.

how to put a plus sign in excel without formula using Apostrophe

Read More: How to Insert Symbol in Excel (6 Simple Techniques)


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.

Steps:

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

how to put a plus sign in excel without formula using Text Format

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

Read More: How to Add Symbol Before a Number in Excel (3 Ways)


Practice Section

We have included practice datasets for each method in the Excel file.


Conclusion

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!


Related Articles

Rafiul Haq

Rafiul Haq

Hello! This is Rafiul. I have an engineering degree and an MBA (finance) degree. I am passionate about all things related to data, and MS Excel is my favorite application. I want to make people's lives easier by writing easy-to-follow and in-depth Excel and finance related guides here at ExcelDemy.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo