I have this decimal format pattern on numeric amount fields with two decimal places and requirement to show trailing sign:
####0.00#;####0.00-
My expectation is that the pattern will produce output that will be aligned on the decimal point. However, this is what I get:
99999.99-
550.00
I thought the hash tag (#) to the right of the positive amount (the first pattern) would produce a space but it does not. Any clues???
John