Negetive Value format

[ib8718]

Hi,

In one of my report I'm using bigdecimal values with negetive sign where negetive sign(-) will be at last position. It's working fine.

But at the report output decimal seperators are bit left for the negetive values than positive values, since I am using right aligned EX:-

            120.00

           120.00-

 

Can you please help me how to place decimal seperator in line for both positive & negetive values.

 

[gregory.west]

You can try this out for the format of the number.  It is not 100% perfect but closer:

#,##0.### ;#,##0.###-

Note the extra space after the 0.## and the ; for the positive number.