Negative number formatting

CJ Koan

On a sheet, is there a way to automatically display negative numbers in a cell other than using a "-" sign? For example (000) or to use conditional formatting to show in red?

Paul Newcome

Conditional formatting can be set up to change the font color to red for any number less than zero.

Paul Newcome

Conditional formatting can be set up to change the font color to red for any number less than zero.