8 Replies Latest reply: Sep 15, 2014 3:45 PM by Scott Brier RSS

    Add sign (+/-) using formatting



      I was wondering if it is possible to add - using formatting options - a leading + or - depending on the value of the number.

      I know one can achieve it like this:


      =if(num(5)<0,'-','+') & '5'


      which should return "+5".

      (e.g. 5 should ofcourse be a dynamic field).