This tutorial will illustrate simple methods of how to type minus sign in **Excel** without a formula. Suppose we are trying to type a minus sign in a cell. In that case, **Excel **considers it as a formula. So, we get an error in return. To solve this problem we will see how we can type minus sign in **Excel**. But, we will do it without using any formula.

**Table of Contents**hide

## Download Practice Workbook

You can download the practice workbook from here.

## 6 Simple Methods to Type Minus Sign in Excel Without Formula

Throughout this article, we will show **6 **simple methods to type minus sign in **Excel **without a formula. To explain these methods we will use the following dataset. In the dataset, we have **5 **numbers. Using different methods we will type minus signs before them. In some examples, we will create a new column containing the numbers with a minus sign. But, in other examples, we will overwrite the existing values with minus signs.

### 1. Apply Insert Tab to Type Minus Sign in Excel Without Formula

First and foremost, we will use the **Insert **tab to type minus sign in **Excel **without a formula. In the following dataset, we’ll insert the minus sign to type the number of cells (**B5:B8**) into cells (**C5:C8**).

Let’s see the steps to perform this method.

**STEPS:**

- To begin with, select cell
**C5**.

- In addition, go to the
**Insert**tab. From the**Symbols**section of the ribbon, select**Symbol**.

- A new dialogue box named
**Symbol**will appear. - Furthermore, select the ‘
**Mathematical Operators**’ in the subset section. - Then, select the symbol
**Minus Sign**.

- The above command will input a minus in cell
**C5**.

- After that, type
**7**in cell**C5**.

- Finally, insert minus sign in the same way for the other values.

**Read More: ****How to Insert Symbol in Excel (6 Simple Techniques)**

### 2. Insert Minus Sign in Excel Without Formula Using Single Quote

In the second method, we will insert minus sign in **Excel **using a single quote before any number. To do this follow the below steps.

**STEPS:**

- First, type
**7**in cell**C5**. - Add a
**single quote**before it.

- Press
**Enter**. - We can see an error in cell
**C5**. - Next, click on the small icon left.
- Then, select the option ‘
**Convert to Number**’.

- The above command returns the value of cell
**B5**with a minus sign.

- After that, repeat the above steps for all the values.
- So, we get results like the following image.

**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 Put 0 in Excel in Front of Numbers (5 Handy Methods)****Insert Dollar Sign in Excel Formula (3 Handy Methods)****How to Add Currency Symbol in Excel (6 Ways)**

### 3. Add Custom Formatting to Type Minus Sign Without Excel Formula

Adding **custom formatting** is very convenient if we want to type minus sign in **Excel **without a formula. In the following dataset, we will insert minus sign before the existing numeric values.

Let’s see the steps to perform this method.

**STEPS:**

- Firstly, select cell (
**B5:B8**). - Secondly,
**right-click**on the selected region. Select the option ‘**Format Cells**’.

- A new dialogue box named
**Format Cells**will appear. - Thirdly, in the dialogue box go to the
**Number** - Select the option
**Custom**from the category section. - Next, in the
**Type**input field insert**-#,###, #,###**. This will give us a preview of the output in the**Sample**. - Then, click on
**OK**.

- Lastly, we can see our desired result in the following image.

**Read More: ****How to Insert Sign in Excel Formula (Arithmetic, Logical and Misc.)**

### 4. Excel Paste Special Multiplication for Typing Minus Sign

In this method, we’ll use the value multiplication from the **Paste Special** options to type minus sign in **Excel**. In the following dataset, we can see the value of the multiplier is **-1**.

Follow the below steps to perform this action.

**STEPS:**

- In the beginning, select cell
**D5**. - Next, press
**Ctrl + C**to copy that value.

- Afterward, select cells (
**B5:B8**). - Then, select the option
**Paste Special**.

- A new dialogue box will appear like the following image.
- After that, check the option
**Multiply**from the**Operation**section. - Now, click on
**OK**.

- As a result, we get minus signs before all the values.

**Read More: ****How to Type Math Symbols in Excel (3 Easy Methods)**

**Similar Readings**

**Insert Rupee Symbol in Excel (7 Quick Methods)****How to Insert Tick Mark in Excel (7 Useful Ways)****Type Delta Symbol in Excel (8 Effective Ways)****How to Type Diameter Symbol in Excel (4 Quick Methods)**

### 5. Type Minus Sign in Excel Without Formula Using Flash Fill Feature

**Flash Fill** can detect a data pattern and fill cells with data following that pattern. In this method, we will use **Flash Fill** to type minus sign in excel without a formula. To do this we will follow the below steps.

**STEPS:**

- To begin with, type the desired value of cell
**B5**in cell**C5**with a minus sign.

- In addition, select cell
**C6**. - Press
**Ctrl + E**. - The above action fills cells (
**C6:C10**). - Furthermore, click the
**small icon****left**. - Then, select the option ‘
**Accept suggestions**’.

- In the end, we get numeric values with minus signs before them.

**Read More: ****How to Add Symbol Before a Number in Excel (3 Ways)**

### 6. Apply VBA Code to Type Minus Sign in Excel Without Formula

If you are an advanced excel user, you can use **VBA** to type minus sign in excel. Using **VBA **has been always quick and easy to accomplish a task in **Excel**. To apply **VBA **in this method we will go with the following steps.

**STEPS:**

- Firstly, select cells (
**B5:B8**).

- Secondly, go to
**the Developer tab**. - Then, select the option
**Visual Macros**from the ribbon.

- A new
**VBA**project window will open. - Thirdly, in that window,
**right-click**on the active sheet named ‘**Sheet7 (VBA)**’. - Then, select
**Insert**>**Module**.

- A new
**VBA**code window will open. - Insert the following code in that code window:

```
Sub TypeMinusSign()
For Each Cell In Selection
If Cell.Value > 0 Then
Cell.Value = -Cell.Value
End If
Next Cell
End Sub
```

- Now, click on
**OK**or press the**F5**key to run the code.

- Lastly, we can see minus signs before the selected numbers in our dataset.

**Read More: ****Excel Formula Symbols Cheat Sheet (13 Cool Tips)**

## Conclusion

In conclusion, this tutorial demonstrates **6 **simple methods to type minus sign in **Excel **without a formula. Download the practice worksheet contained in this article to put your skills to the test. If you have any questions, please leave a comment in the box below. Our team will try to respond to your message as soon as possible. Keep an eye out for more inventive **Microsoft Excel** solutions in the future.

## Related Articles

**How to Insert Degree Symbol in Excel (6 Suitable Methods)****Insert Symbol in Excel Header (4 Ideal Methods)****How to Insert Symbol in Excel Footer (3 Effective Ways)****Put Equal Sign in Excel without Formula (4 Easy Ways)****How to Put a Plus Sign in Excel without Formula (3 Easy Methods)****Insert Greater Than or Equal to Symbol in Excel (5 Quick Methods)****How to insert square root symbol in Excel (7 easy ways)**