How to format negative currency values (remove () )?.

Avatar

Avatar

LittlePenguin

Avatar

LittlePenguin

LittlePenguin

28-02-2014

Hi, I have a field that ocasionally can contain negative raw values.

What happens is, when a negative raw value is fed to the field, the field looks like this:

($999.999,00)

And I'd like it to look like this:

-$999.999,0

Any ideas how to do this?, I couldn't find any option in the patterns section.

Thanks!.

View Entire Topic

Avatar

Avatar

Francis_Manly-E

Avatar

Francis_Manly-E

Francis_Manly-E

28-02-2014

Placing a capital S before the $ will result in a negative sign appearing before the $ symbol  as  desired.