How to force minus sign?
How to force minus sign?
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!
-
- Posts: 47
- Joined: Tue Oct 10, 2017 12:44 pm
=> RE: How to force minus sign?
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