Change Formatting of Negative Amounts

[alutz54]

Hi all, I have several tables in my sheet that have dollar amounts with both positive and negative values. I want to be able to sort the tables by their absolute values, or even better for the end user, format all negative values to not have the negative sign and be enclosed in parentheses. I.e. -$2000 becomes ($2000). Any thoughts?

[BrunPierre]

Try.

Num(Field,'$#,##0;($#,##0)')

[alutz54]

Do I need any sort of IF statement with it?  As is, that doesn't seem to work.

[Chanty4u · Accepted solution]

Try this in your custom format

$#,##0.00;($#,##0.00)

[alutz54]

Yes! Thank you!