If I'm using this:

=NumberFormat({$_},"###,###",posColor="#00000",negColor="#00000")

How do I also keep the parenthesis for negative numbers??

Thanks,

Devon

this is what i use=NumberFormat({$_},"#,###;<font color='red'>(#,###)</font>")

soo=NumberFormat({$_},"#,###;<font color='black'>(#,###)</font>")

Thanks @Travis Cole, this formula works. however now I am losing the "$" prefix. I got on back with this:

=NumberFormat($_,"###,###;<font color='black'>(###,###)</font>",posPrefix="$",negPrefix="$")

Curious if there are also other options for the "$"......

This seems to work pretty well too:

=NumberFormat($_,"¤#,###;<font color='black'>(¤#,###)</font>")

@Pieter van Dam, @Lucas Wolters nice to know and to remember.