How to force minus sign?

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
LGM
Posts: 5
Joined: Tue Oct 10, 2017 12:44 pm

How to force minus sign?

Post by LGM » 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!

Chris_Strasser_(Guest)
Posts: 47
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: How to force minus sign?

Post by Chris_Strasser_(Guest) » 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

Post Reply