How to Enter a Negative Number in Excel Correctly

How-to basics · Updated November 20, 2026

To enter a negative number in Excel, select a cell, type a minus sign followed by the number, such as -25, and press Enter. Excel stores it as a numeric value, so you can use it in calculations. You do not need a special setting for ordinary negative numbers; if Excel displays the value unexpectedly or treats it as text, check the cell format and entry method.

What You’ll Need

  • A workbook open in Microsoft Excel for Microsoft 365 on Windows.
  • A blank cell or an existing cell whose contents you are ready to replace.
  • The number you want to enter, including its minus sign. For decimals, use the decimal separator your Excel settings expect.

The steps below also work in most recent desktop versions of Excel. Excel for Mac and Excel for the web use the same basic minus-sign entry method; notes about differences appear where they matter.

Step-by-Step

  1. Select the cell. Click the cell where the negative value should go. If you are entering several values, choose the first cell in the column or row. Check that you have selected the intended location, especially if the worksheet contains formulas or existing data.
  2. Type the minus sign first. Enter a standard hyphen-minus, followed immediately by the digits. For example, type -25 for negative twenty-five or -3.75 for negative three and three-quarters. Do not put a space between the sign and the number. A dash copied from formatted text, such as an en dash, may not be recognized as a numeric minus sign.
  3. Confirm the entry. Press Enter to commit the value. Excel normally moves the selection down one cell. You can also press Tab to commit it and move one cell to the right. The cell should show a minus sign before the number unless its number format is set to display negatives another way.
  4. Check that Excel stored a number. Select the cell again and look at the formula bar above the worksheet. A numeric negative value normally appears there with its minus sign. As a quick additional check, temporarily choose Home > Number Format dropdown > General. If the value is still a negative number and can be used in arithmetic, it is numeric. Changing the display format does not change the underlying value.
  5. Enter a negative value with a formula when appropriate. A formula can create a negative number or calculate one from other cells. No cell layout is required for this constant formula: type =-25 into a cell and press Enter; the result is -25. If you are calculating a difference, assume the starting amount is in A1 and the ending amount is in B1: enter =A1-B1 in C1. If A1 contains 40 and B1 contains 55, C1 returns -15. The equals sign tells Excel to calculate rather than store the typed characters as a plain value.
  6. Choose how negatives should look, if needed. To display the value with commas, decimals, or a currency symbol, select the cell and use the number-format controls on the Home tab. For more choices, open Format Cells: press Ctrl+1 on Windows, select the Number tab, choose a category such as Number or Currency, then select a negative-number style. On Mac, Command+1 opens Format Cells in many current Excel releases; if that shortcut is intercepted by macOS, use the Format Cells command from Excel’s menus. The formatting changes appearance, not the stored number.
  7. Fill more cells without changing the sign. For a list of negative entries, type each value with its own leading minus sign. If you copy a negative value, ordinary paste copies it as a negative value. If you fill a formula down, check whether its cell references should adjust; Excel usually changes relative references as the formula moves.
  8. Verify the value in a calculation. A negative number should behave as a number in arithmetic and sorting. For a simple check, use an empty cell to add the value to zero or compare it with another number. Avoid relying on color alone: some formats show negative values in red, while others use parentheses or a minus sign, and color can be difficult to distinguish.

Common Mistakes

Typing an apostrophe before the minus sign. An entry such as '-25 is stored as text, not as a numeric negative value. Excel may display the characters in the cell, but arithmetic and numeric sorting can then behave differently. If you do not want the apostrophe, remove it and enter the number again.

Using a dash that is not a minus sign. Text copied from a website or document may contain a longer dash. Replace it by deleting the sign and typing the ordinary minus key from your keyboard.

Confusing the display with the value. A format can show negative numbers in parentheses, such as (25), or in red without a minus sign. That does not necessarily mean the value is positive. Select the cell and inspect the formula bar or use a simple calculation to confirm.

Overwriting a formula or another cell’s contents. Typing into a selected cell replaces its existing contents when you commit the entry. Check the cell address and formula bar before replacing anything you need to keep.

Tips

For a quick one-off entry, typing the minus sign and digits directly is usually the clearest approach. Use a formula when the value should update based on other cells, such as a difference between an amount received and an amount spent. This keeps the result connected to the inputs instead of leaving a fixed number that must be edited by hand.

Decide on a consistent display for a column. For example, Number format can show a minus sign, while an accounting-style format may align currency symbols and display negatives in parentheses. Tell readers which convention the sheet uses if the format could be mistaken for something else.

When entering a whole column of values, format the destination cells before typing if you need a particular number of decimal places or currency style. On Windows, Ctrl+1 opens Format Cells; on Mac, try Command+1. In Excel for the web, the direct minus-sign entry works the same way, but formatting options may be arranged differently from the desktop dialog.

If you are entering a value below zero into a chart or report, remember that the underlying number remains negative even if a chart or custom format makes it look unusual. Keep a copy of the original data before applying complex custom formats.

Troubleshooting

The cell shows a minus sign, but formulas do not calculate with it. The entry may be text. Select the cell and inspect the formula bar for a leading apostrophe. If one is present, remove it and enter the value again. If the cell was formatted as Text before entry, change it to General using Home > Number Format dropdown > General, then re-enter the value. Changing the format alone may not convert text already stored in the cell; edit and recommit the entry, or use Excel’s available text-to-number conversion prompt if it appears.

The number appears without a minus sign. Select the cell and look at the formula bar. If the formula bar shows a negative value but the cell does not, the number format may be hiding or replacing the sign. Open Format Cells with Ctrl+1 on Windows or Command+1 on Mac, then choose a standard Number format with a visible negative style. Also check for a custom format applied to the cell or its entire column.

Excel changes the entry into a date or another display. This is often a formatting issue rather than a change to the stored value. Set the cell to General or Number and enter the value again. If the value was intended to be a date, use a date entry rather than a negative number; Excel stores dates as serial numbers, so changing a date cell to General can reveal a number that is not the amount you meant to enter.

The decimal portion is not recognized. Excel uses the decimal and thousands separators set by your regional settings. If a decimal entry is not interpreted as expected, check Excel’s regional or system separator settings and use the decimal symbol configured for your installation. Do not add thousands separators casually; in some locales, commas and periods have opposite roles.

You cannot tell whether a copied value is numeric. Paste it into a blank cell formatted as General and inspect it in the formula bar. If it remains text, retype the value using the keyboard minus sign. If many imported values are affected, correct a small sample first and confirm the result before converting the whole column.

Frequently Asked Questions

Do I need to type an equals sign before a negative number?
No. Type -25 directly for a fixed numeric value. Start with an equals sign only when you want Excel to calculate a formula, such as =-25 or a cell-reference calculation.

Can I enter negative numbers in Excel for Mac or the web?
Yes. Select a cell, type the minus sign and number, then press Return or Enter. The basic entry behavior is the same. Some formatting dialogs and keyboard shortcuts differ by platform; on Mac, Command+1 commonly opens Format Cells, while the browser version has a more compact ribbon interface.

Why does Excel show a negative number in parentheses?
The cell is probably using a number, currency, accounting, or custom format that displays negatives in parentheses. The stored value can still be negative. Select the cell and check the formula bar, or apply a standard Number format to show a conventional minus sign.

How do I make a number negative with a formula?
If you want a fixed result, enter =-25. If a positive value is in A1 and you want its negative in B1, enter =-A1 in B1; when A1 is 25, B1 returns -25. If the source might already be negative, multiplying it by -1 will reverse its sign, so choose the formula that matches your goal.

Can I type a negative zero?
You can enter -0, but Excel generally treats it as zero for ordinary spreadsheet calculations and may display it as 0. If you need to distinguish a special state such as “less than zero but rounded to zero,” keep that information separately rather than relying on negative zero.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.