1 Reply Latest reply: May 31, 2011 10:58 AM by Erich Shiino RSS

    Format number in Text in Chart

    Guy Vermeiren

      Hello,

       

      I would like to fomat my numbers in my calculated Text in Chart.

       

      I tried this to have a thousand separator but without success

       

      ='Target='&Num#(vTargetOpptyNL,'#.#')

       

      Any idea how to ?

       

      Thanks,

      Guy

        • Format number in Text in Chart
          Erich Shiino

          num# will convert a text into a number. You need num() that will make the opposite:

          try this:

          ='Target='&Num(vTargetOpptyNL,'#,###', '.', ',')

          That's if your thousand sep. is , and your decimal sep is .

           

          If  vTargetOpptyNL is an expression, you may need to evaluate it:

          ='Target='&Num($(vTargetOpptyNL),'#,###', '.', ',')

          or

          ='Target='&Num($(=vTargetOpptyNL),'#,###', '.', ',')

          Hope it helps,

           

          Erich