Page 1 of 1

How to force minus sign?

Posted: Tue Feb 02, 2016 2:37 pm
by LGM
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
by Chris_Strasser_(Guest)
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