how to change the value from -$### to [red](#,###.##)?

[Harrold]

hi,

how to change the value from -$### to [red](#,###.##) in query? Can someone please advise me?

Thank you very much

 

[John Big Booty]

If what you are after is for negative numbers to display in Red within parenthesis, then use;

$#,##0.00;($#,##0.00)[Red]

In the format property of the field required.