How to add a plus sign in Microsoft Excel
Adding a plus sign is a frequently performed task in Microsoft Excel. It is typically used to include country codes when noting employee contact numbers in many organizations. Additionally, the plus sign can be utilized to display price variations. In the case of indicating an increase in price or any other numerical value, using the plus sign is a useful method.
In this tutorial, we will learn how to add a plus sign in Microsoft Excel. Microsoft Excel does not allow adding plus sign by default. To add a plus sign to a number or text, one can either use a single quote, create a custom format, or can convert the data to text format.
Method 1: Using a Single Quote to Add a Plus Sign
Step 1 – Double-Click to Edit the Data
- Double-click on the cell to edit the data
Step 2 – Enter a Single Quote
- Enter a single quote at the start of the text or the number.
Step 3 – Enter the Plus Sign and Press the Enter Key
- Now enter the plus sign.
- Press the Enter key.
- Repeat the steps for each cell.
Method 2: Using a Custom Format
Step 1 – Select the Range of Cells and Right-Click on the Cell
- Select the range of cells containing the data in which you want to add the plus sign.
- Right-click on the cell in which you want to enter the plus sign.
- A context menu will appear.
Step 2 – Click on the Format Cells Option
- Click on the Format Cells option in the context menu.
Step 3 – Select the Custom Option
- Select the Custom option as a format in the Category section.
Step 4 – Enter +0 in the Type Field
- Enter “+0” in the “Type” field to add a plus sign before a number.
- We can add “+@” for text.
Step 5 – Click on the OK Option
- Click on the OK option in the Format Cells dialog box.
- A plus sign will be added.
Method 3: Changing the Format to Text
Step 1 – Select the Range of Cells and Right-Click on the Cell
- Select the range of cells containing the data in which you want to add the plus sign.
- Right-click on the cell in which you want to enter the plus sign.
- A context menu will appear.
Step 2 – Click on the Format Cells Option
- Click on the Format Cells option in the context menu.
Step 3 – Select Text as Format
- Select the “Text” option as the format.
Step 4 – Click on OK
- Click on OK in the Format Cells dialog box.
Step 5 – Add a Plus Sign
- Add a plus sign to the number or text.