How simply get preceding + sign

[sergio0592]

Hi all,

I'am looking for a little simple thing : in a text box id'like to add a preceding + ou - sign depends my kpi is negative or positive. I want avoid condition (if KPI > 0, '+'&KPI Value....). 

By default - sign appears when value is negative but no + when positive.

Any idea?

[marcus_sommer · Accepted solution]

It could be reached just with a formatting like:

=num(YourNumber, '+ #.##0,00;- #.##,00')

- Marcus