Customize number format to show red and dollar sign and brackets

[President]

please see screenshot below.

the one shows in red is the custom format i need

 

[thisoldman]

Re: questiion on how to customize number format to show red and dollar sign and brakets

Try this,

$* #,##0.00;[Red]$* (-#,##0.00);$* "-"??;@

It produces a hyphen for zero values.

 

[MrTeeny]

Re: questiion on how to customize number format to show red and dollar sign and brakets

Too slow

 

[President]

Re: questiion on how to customize number format to show red and dollar sign and brakets

excellent, thanks very much thisoldman

Try this,

$* #,##0.00;[Red]$* (-#,##0.00);$* "-"??;@

It produces a hyphen for zero values.

 

[thisoldman]

Re: questiion on how to customize number format to show red and dollar sign and brakets

Thank you for telling us we solved your problem.