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 with a minus sign in the front.

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 WORKBOOK

Number Formats - Negatives

 HELPFUL RESOURCE:

728x90

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Drop Down List with Data Validation One of the coolest features of Excel is to create a drop down list with your data.  It is one of the first things that I learned and use on a daily basis.You can create a drop down list to eliminate manual entry and re-entry of data, as well as reduce data entry mistakes if y...
Use Excel Goal Seek To Find The Formula Result You... If you have a formula and want to show a specific result, but you do not know what input values to change within the formula, then Excel's Goal Seek feature is the one for you.Imagine you are calculating the payment terms on a loan.Your PMT formula gives you an amount of ...
Clear a #REF! Error in Excel When your Excel workbook has formulas that are linked to other workbooks/cells that have been deleted, you will get a #REF! error.This means that the formula refers to a cell that isn’t valid.To get rid of this error message we have to select the cell(s) with this error, ...
Adding Data Labels To An Excel Chart Data Labels make an Excel chart easier to understand because they show details about a data series or its individual data points.Depending on what you want to highlight on a chart, you can add labels to one series, all the series (the whole chart), or one data point.In ou...