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

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.

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

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.

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.

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.

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

## 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 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

Advanced Excel Exercises with Solutions PDF