Signing ( + / - ) on straight table looks great on app, but has both + and - on export

[110]

A picture ( or two ) is worth a thousand words.

In app : 

In Excel export :

Not sure what to do here?

I had ' +0#' as the format , to add the + where positive, I also tried   " num(MyValue, '+ #.##0,00; - #.##0,00; +/- 0,00')"  but this didn't work either..

[Mark_Little]

NUM(100,'+#,##0.00;-#,##0.00;')

Works fine for me, Could be related to you down arrow throwing it off?

[110]

Thanks @Mark_Little   - in the end I just removed the formatting to add the '+' , and left the arrow as  ( hopefully ) it'll be used more on screen than in exports.