[Migrated content. Thread originally posted on 19 April 2010]
I want my report to show-$100.00
The acu docmentation tells me that the - sign and $ are mutually exclusive in a pic clause. I can set it up to show,
$100.00-
but when the report is exported to excel it does not recognize that as a negative number since the - sign is trailing. If I set up as -$$$,$$$.99 it shows the minus sign but it looks like:
- $100.00
with the - sign to the far left. I would like it to float to just to the left of the $ sign.
I am missing something simple here as I cannot seem to achieve this,
