Page 1 of 1
How to force minus sign?
Posted: Tue Feb 02, 2016 2:37 pm
Hello,____My numeric & currency fields are all defaulting to parens for negative values.____How do I get them to default to a minus sign?____Regional settings are set to minus for both numeric and currency.____R&Rv12 Build 12.5.001__Windows 7____Thanks!
=> RE: How to force minus sign?
Posted: Thu Jun 09, 2016 3:03 pm
The easiest way is through the TRANSFORM() function:____TRANSFORM(-8382, "9,999,999")____returns____-8,382____However, it becomes a character field. It^s just for formatting output. As a character field, you can always add a "$" in front:____"$" - TRANSFORM(-8382, "9,999,999")____will return____$ -8,382