ExcelBanter - negative numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - negative numbers (https://www.excelbanter.com/excel-worksheet-functions/162888-negative-numbers.html)

Flyguy

negative numbers

How do I get a negative number to appear in red with a minus sign instead of
brackets or a minus sign in black?

JE McGimpsey

negative numbers

If the option doesn't appear in your Format/Cells/Number dialog, one way:

Choose Format/Cells/Number/Custom General;[red]-General;General

In article ,
Flyguy wrote:

How do I get a negative number to appear in red with a minus sign instead of
brackets or a minus sign in black?

All times are GMT +1. The time now is 02:45 PM.