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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Text to Columns – Emails If you have a data set with text consisting of names and email addresses that are wrapped inside a parenthesis, like: John (john@email.com)   ...then you can use the Text to Columns feature in Excel to take out the email addresses and put them in a separate ...
Excel Filter by Selection When you have an array of data in Excel you can quickly select an item and press the AutoFilter button which will filter that selection in your data. You can then go over to another column within your data and select another item, apply the same steps above and further filter ...
Show The Percent of Parent Row Total With Excel Pi... Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF PARENT ROW TOTAL calculation. This is a new calculation in Excel 2010 and onwards. This option will immediately calculate the percentages f...
Autofill Formulas in an Excel Table One of the advantages of using an Excel Table is the ability to autofill a formula all the way down your data without having to copy and paste. When you write a formula anywhere in your Excel Table, it will automatically fill down and up within that column. As you add extra...