I need to take a String that contains a double (something like 14562.34) and format it so that it looks like $000,000,00#.##-. What I mean by that is the $ will be all the way to the left, the 0s above won't show up if a number is not there but I do want the spacing to be there. The #s will be digits and I need at least 0.00 to show up if the number is zero. The '-' will show up if the number is a negative(though I believe that is something I can tack on at the end w/o the formatter). When I try doing "000,000,00#.##" for the formatter I get a malformed exception.
Would anyone have tips on doing this or on what I am doing wrong?
Here are examples:
1234.56 -> $______1,234.56
0 -> $__________0.00
1234567.89 -> $__1,234,567.89
Where the '_' represents a space still there.
Thanks.