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

Get FREE Advanced Excel Exercises with Solutions!

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


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.

Steps:

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

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 +@ 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 Type Minus Sign in Excel Without Formula


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.

Steps:

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

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

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.

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

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.

Steps:

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

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.


Practice Section

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


Download Practice Workbook


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


<< Go Back to Mathematical Symbols in Excel | Insert Symbol in Excel | Excel Symbols | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Rafiul Haq
Rafiul Haq

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo