7 Replies Latest reply: Dec 27, 2012 9:32 AM by Jonathan Brough RSS

    num() - returning a blank/space as thousand delimiter

    Richard Sheppard

      Hi All,

       

      I have a text field whereby I would like to replace the thousand delimeter from a comma to return a blank/space instead

       

      Formula to convert text to return a comma as thousand delimeter:

      =num([FTL Price],'#,###')

       

      Changing the above to return a space:

      =num([FTL Price],'# ###')

       

      this returns

      " 2070 ### "

       

      does anyone know how I adapt my formula, so that it displays "2 070" instead?

       

      I've changed my "Main" script tab, so that thousands are a space - but don't think this is the issue...?

       

      SET ThousandSep=' ';

       

       

      Any thoughts greatly appreciated...

       

      Kind regards,

       

      Rich