I am trying to format a column with D12.2-!D (giving 2 decimal space, with dollar sign and setting minus symbol if there is a negative value).
In output i am getting the number s

  $20.45- 

i need the output as

      -$20.45 

Any idea why this formatting shows the output differently?

Regards

You should just use D12.2!D NOT D12.2-!D

The '-' in the format for a field displays a -ve sign to the right of the number, as stated in the manual. This changes the normal position which is a leading -ve sign.

Just use D12.2!D to get a leading -ve sign

It worked. Thanks.