To change how negative numbers look in Excel, select the cells, press Ctrl+1 on Windows, choose Number, and pick a negative-number style; on Mac, press Command+1. You can also use a custom format to show negatives in red, in parentheses, or with a different number of decimal places without changing the values themselves.
What a number format changes
A number format controls how a value is displayed, not the value stored in the cell. If a cell contains -1250.5, formatting it to show parentheses might display (1,250.50), but Excel still stores a negative number. Formulas, sorting, comparisons, and charts continue to use the underlying value.
This distinction matters when you share a workbook or use its figures elsewhere. A minus sign is often the clearest signal for a general audience. Parentheses are common in accounting and financial reports, while red text can make losses or shortfalls stand out. Choose a display style that makes the sign easy to understand, particularly when figures may be printed in black and white.
Formatting is also different from typing a minus sign into a text string. A true number such as -25 can be added, averaged, and used in calculations. Text that merely looks like -25 may not behave as a number in formulas. In ordinary cells, enter a negative value with a leading minus sign and then apply the format.
Use a built-in negative-number style
Excel’s Number format options offer ready-made ways to display negative values. To apply one in Excel for Microsoft 365 on Windows:
- Select the cells you want to format. Avoid selecting a heading if it is part of the same column.
- Press Ctrl+1 to open Format Cells. You can also use the dialog launcher in the Home tab’s Number group.
- On the Number tab, choose Number, Currency, or another suitable category.
- Set the decimal places and, where available, select a negative-number appearance from the examples.
- Choose OK and check that positive and negative values are both easy to read.
On Excel for Mac, Command+1 opens Format Cells. The dialog’s labels or layout can vary slightly by release, but look for the Number category and its negative-number choices. In Excel for the web, use the number-format controls on the Home tab; some detailed format options are more limited than in the desktop app, so open the workbook in desktop Excel if you need to create or edit a complex custom format.
Number is a good general-purpose category when values represent counts or measurements. Currency and Accounting are more suitable for money. Currency typically places the symbol beside the number; Accounting aligns currency symbols and decimal points in a column, which can make a financial table easier to scan. The exact negative examples available can depend on the chosen category and regional settings.
Choose between a minus sign, parentheses, and red text
These styles communicate the same mathematical fact in different ways. For a list of ordinary measurements, a minus sign is familiar and compact. Parentheses can fit a formal report or accounting statement. Red text adds visual emphasis, but it should not be the only indication that a value is negative: readers may print in grayscale, have color-vision differences, or view the sheet with colors changed.
- Minus sign: a display such as -1,250.50 is direct and widely understood.
- Parentheses: a display such as (1,250.50) is often used in financial statements. Make sure the column heading or a note makes the convention clear to readers who may expect a minus sign.
- Red numbers: the sign remains visible while color draws attention to the value. Red can be combined with either a minus sign or parentheses.
For example, if a report contains a positive 2,000 and a negative 1,250, a parenthesis style might display them as 2,000.00 and (1,250.00). The underlying values remain 2000 and -1250. If the report instead uses a minus sign, the negative value appears as -1,250.00. Use one convention consistently throughout a table.
Create a custom number format
When the built-in choices do not match the worksheet, use a custom format. Select the cells, open Format Cells with Ctrl+1 on Windows or Command+1 on Mac, choose Custom, and enter a format code in the Type box. This example shows two decimal places, colors negative values red, and encloses them in parentheses:
#,##0.00;[Red](#,##0.00)
The first section applies to positive numbers and zero; the second applies to negative numbers. The comma adds thousands separators, and the zero and two digits after the decimal point specify two decimal places. In this format, 1234.5 displays as 1,234.50, while -1234.5 displays as (1,234.50) in red. The cells still contain the original numeric values.
Custom formats can have up to four sections separated by semicolons: positive values; negative values; zero; text. For example, this format displays positives with two decimals, negatives in red parentheses, zeros as a dash, and text as entered:
#,##0.00;[Red](#,##0.00);-;@
The third section controls zero values, so the dash in that section is a visual substitute for zero, not a change to the stored value. The fourth section uses @ as a placeholder for text. If you omit a section, Excel applies its format-section rules to the remaining values; when in doubt, include the sections you intend to control and test with positive, negative, zero, and text entries.
For percentages, the displayed number is scaled by 100. For instance, a cell whose value is -0.125 can display as (12.5%) using 0.0%;[Red](0.0%). Do not enter -12.5 if the cell is meant to represent negative 12.5 percent: that value would display as -1,250.0% under a percentage format.
Apply the format consistently across a worksheet
Before applying a style, decide which values belong together. A single column of expenses may use one format, while a neighboring percentage column needs a different one. Select only the relevant data cells, or select the full data range if new rows should follow the same convention. Applying a format to an entire column can be convenient, but it may also affect headings or unrelated entries in that column.
Tables and copied ranges may bring their own formatting along with values. If pasted data unexpectedly loses the negative style, check the paste options: a paste that includes source formatting can replace the destination format. If you need to preserve the destination’s appearance, use a paste option that keeps destination formatting or paste values only, as appropriate. Recheck the number format after importing data from another workbook or a text file.
A useful quality check is to include one positive value, one negative value, and zero in a sample of the formatted range. Also inspect a value with more decimal places than the display allows. The display may round it, but the stored value remains unchanged and calculations continue to use that more precise value.
Number format or conditional formatting?
Use a number format when you want the same display rule to apply to every negative value in a range. It is part of the cell’s formatting and travels with the cell when the format is copied. A custom format such as #,##0.00;[Red](#,##0.00) can show negative values in red without a separate rule.
Use conditional formatting when the emphasis depends on a condition or when you want to change more than the number’s appearance. For example, in Excel for Microsoft 365 on Windows, select the range and choose Home > Conditional Formatting > Highlight Cells Rules > Less Than, then enter 0 and choose a style. This can apply a font color or fill to values below zero while leaving the number format intact. On Mac, the Conditional Formatting controls are also on the Home tab, though the dialog arrangement can differ.
Conditional formatting is useful when a rule applies only to part of a table or when thresholds may change. A number format is simpler for a consistent sign convention. The two can coexist, but overlapping rules may make the final color or appearance less obvious; review the rules if a cell does not look as expected.
Common problems and how to fix them
- Negative values still show a minus sign: verify that the selected cells have the intended format and that the custom code has a negative section after the first semicolon. If you used a built-in category, check that you selected a negative example rather than only changing decimal places.
- Numbers appear as ####: the column may be too narrow to show the formatted value. Widen the column or reduce the number of displayed decimal places. Hash marks do not normally mean that the underlying number has disappeared.
- A small negative appears as -0.00: the stored value may be negative but close to zero, such as -0.004, while the format displays only two decimal places. Excel rounds the display, not the value. Increase decimal places to inspect it, or change the calculation if the business rule genuinely treats such a value as zero.
- Red formatting is missing: check the spelling and brackets in a custom color code such as [Red], and check whether conditional formatting or another style is affecting the same cells. Color names and available display choices can vary with the application’s format support and locale.
- A negative date displays as hash marks: date and time values are not ordinary negative-number displays. In the standard 1900 date system, Excel cannot display dates earlier than its supported starting point as normal dates, so changing the negative-number style will not solve the issue. Check whether the cell is intended to contain a date, a duration, or a numeric value.
Another frequent cause is numbers stored as text. If a value is text, a number format may not change how it appears or make it usable in arithmetic. Check whether the cell is left-aligned unexpectedly, has a warning indicator, or was imported with a leading apostrophe. Convert it to a number using an appropriate conversion method before relying on number formatting.
How to choose the right style
Start with the people who will read the workbook and the purpose of the figures. For operational data, use a minus sign and enough decimal places to communicate the measurement. For a financial report, parentheses may match the organization’s established convention. For a dashboard, red can help flag negative results, but retain a minus sign or parentheses as a non-color cue.
Then consider the unit and precision. Counts generally do not need decimal places; prices may need two, while scientific measurements can require more. Avoid showing many digits simply because they exist, but do not hide meaningful precision. If displayed rounding could affect decisions, document the rounding convention or show the underlying precision elsewhere.
Finally, test the format in context. Check how it looks beside the column heading, whether columns align, and how the sheet prints or exports to PDF. A format that looks clear on a wide monitor may be cramped on a printed page. Number formatting is a presentation choice, so the best option is the one that communicates the sign, unit, and precision clearly without misleading the reader.
Frequently Asked Questions
How do I show negative numbers in parentheses in Excel?
Select the cells, open Format Cells with Ctrl+1 on Windows or Command+1 on Mac, and choose a built-in negative style if available. For a custom style, choose Custom and use a code such as #,##0.00;(#,##0.00).
How do I make negative numbers red in Excel?
In Format Cells, choose a built-in red negative style or use a custom format with [Red] in the negative section, such as #,##0.00;[Red](#,##0.00). Conditional formatting is another option if color should depend on a rule.
Does changing the negative-number format change the value?
No. Number formats change how a value appears, not its stored amount. A value of -1250 can display as -1,250, (1,250), or a red number and still be used as -1250 in calculations.
Can I hide zero values but keep negative numbers visible?
Yes. In a custom format, the third section controls zero. For example, #,##0.00;[Red](#,##0.00);;@ leaves zero values visually blank while retaining the underlying zero. Consider whether a blank display could be mistaken for missing data.
Why does Excel show #### instead of a negative number?
The column is often too narrow for the chosen format, especially when parentheses, separators, or decimals add characters. Widen the column or reduce displayed decimal places. For negative dates, the date system or date value may be the issue rather than the column width.
Related
- Microsoft Excel Zoom Out: Ways to Shrink the View
- Microsoft Excel vs Apple Numbers: Which Should You Use?
- Microsoft Excel Transpose Table: Methods, Limits and Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Detect Circular References in Excel: Step-by-StepTo detect a circular reference in Excel for Microsoft 365 on Windows, open the Formulas tab, choose Error…
- Debt Snowball Spreadsheet: Build One in ExcelYes—you can create a debt snowball spreadsheet in Excel by listing debts from smallest balance to largest, calculating…
- Password Protect Multiple Excel Files at Once in ExcelYes. In Excel for Microsoft 365 on Windows, you can password-protect multiple workbooks by running a VBA macro…
- How to Add a Header and Page Number in Word EasilyTo add a header and page number in Word, open the header area by choosing Insert > Header,…
- Excel Power Query Find and Replace: Steps and TipsTo find and replace data in Excel Power Query, open the query, select the column, then choose Transform…
- How to Merge Cells in Excel: Steps, Options, and FixesTo merge cells in an XLS workbook in Excel for Microsoft 365 on Windows, select the adjacent cells,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.