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+