# How to insert a Plus Sign in Excel without a Formula – 3 Methods

The dataset showcases employee information: Name, Department, and Phone.

A Plus (+) sign is usually used for Phone Numbers and for price fluctuations.

### Method 1- Using the Custom Format Feature to Insert a Plus Sign in Excel

Steps:

• Select range D5:D10 andÂ press CTRL + 1.

In the Format Cells dialog box:

• Select Custom in Category.
• Enter +0 in Type:
• Click OK.

This is the output.

• If you have text, enter +@ in Text:.

### Method 2 – Insert a Plus Sign in Excel by Using a Single Quote

This Single Quote orÂ Apostrophe () will consider the value as text. A dash was added to the phone number.

Steps:

• Double-click D5 and add a plus sign with Apostrhope (‘+). You can also click D5 and click the formula bar.
• Press ENTER.

This is the output.

Repeat the process for other cells.

If you have a large amount of data, follow the first method.

### Method 3 – Formatting as Text to Insert a Plus Sign in Excel

Format values as Text using the Ribbon toolbar.

• Select D5:D10.
• Go to the Home tab >> Number Format >> Select Text.

Values are formatted as Text.

• Double-click D5 and add a plus sign.

• Repeat the process for the rest of the cells.

This is the output.

Practice here.

## Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
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