Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
2 posts • Page 1 of 1
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!
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