Negative Number and Zero Formatting.

[BREW78]

Hi All.

I want to format negative numbers in brackets and format zeros as "-" not "0".

Currently I display negative numbers in brackets using the below custom number format:

#,##0;(#,##0)

However using this format zeros display as "0" and I want zeros to display as "-".

Appreciate any answers to this question.

Thanks.

BREW78.

 

[Rick Rothstein]

I want to format negative numbers in brackets and format zeros as "-" not "0".

Change the cell format to this custom format Type pattern...

[<0](#,##0);[=0]-;General

 

[joeu2004]

Currently I display negative numbers in brackets using the below custom number format:
#,##0;(#,##0)
However using this format zeros display as "0" and I want zeros to display as "-".

#,##0;(#,##0);-

The third field applies when the value is exactly zero.

However, things will align better, IMHO, with the following format:

#,##0_);(#,##0);-_)

The _) specifier appends space with the width of a right-parenthesis, which appears when the value is negative.