Pinterest Pixel

How To Make Negative Red Numbers In Excel

How To Make Negative Red Numbers In Excel When you are working with lots of different numbers... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

How To Make Negative Red Numbers In Excel | MyExcelOnline How To Make Negative Red Numbers In Excel | MyExcelOnline

How To Make Negative Red Numbers In Excel

When you are working with lots of different numbers in Excel, you sometimes want your numbers to stand out by showing them in a negative red number enclosed in parenthesis.

To do this you need to select your numbers and press CTRL+1 to bring up the Format dialogue box.

From there you need to select the Number tab and the Number category and choose the 4th selection (1,234.0)

You can then select the number of decimal places to show and also insert a 1000 separator.

Download workbookNumber-Formats-Negatives.xlsx

 

STEP 1: Select the column that you want to apply the negative number formatting. Press CTRL + 1 to open the Format Dialog.

How To Make Negative Red Numbers In Excel

 

STEP 2: Select Number as the category and select the formatting that you want to display for negative numbers. You can change the number of decimal places as well.

Click OK.

How To Make Negative Red Numbers In Excel

Now your negative numbers are now formatted!

How To Make Negative Red Numbers In Excel

If you like this Excel tip, please share it
How To Make Negative Red Numbers In Excel | MyExcelOnline How To Make Negative Red Numbers In Excel | MyExcelOnline
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  Find Errors with Go to Special Constants

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...