Ricki,
Now I see your problem, I just selected the standard format
$#,##0.00;($#,##0.00)
Replaced the commas with spaces:
$# ##0.00;($# ##0.00)
and ran some test.
1 returns $1.00
1234 returns $1 234.00
however the calculations are treating the 1 234 as two numbers. If I
add
$ 1 234.00 and $2.00 I am getting $237.00 or 1 + 234 + 2
I am stumped right now :-(
|