I want numbers to show up without the 1000's, but have the real numbers
entered... I have some references to build on, but when I try to modify them
to my need, I get an undesired result.
What I want:
-$100,000 would show as $(100)
$100,000 would show as $100

What I have that works:
$#,###, truncates positive numbers as shown above.

The specific instance I need help with is this custom format (inherited &
modified based on the working ref above)
_($* #,###,);_($* (#,###,);_($* "-"??);_(@)

-100,000 shows as $(100)
100,000 shows as $100)

I would like to have $100,000 show as $100 (no end parenthesis), but still
retain the () for negative numbers.

Since I am new at this, I'd appreciate suggested formatting, plus a brief
explanation of what each piece means.

--
Thanks for your help,
Christopher