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

**Table of Contents**hide

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

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

**Similar Readings**

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

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

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

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

- 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

**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)**