16 Replies Latest reply: Apr 22, 2015 8:07 AM by Ilonka Bachmann RSS

    Format Number with apostrophe

      Hi all,

      I would like to format a number in an expression. The format should look like this: 999'999.00

      I've tried several things, but I cant get the result I whish.

       

      if i use; =num(amount,'#''##0.00','.',chr(39))  the result looks like this: 99'9'999.00

       

      when replacing the 2 apostrophe with a comma =num(amount,'#,##0.00','.',chr(39))  the result looks like this: 999999,# #0.00

       

      Can someone tell me how to format this number correctly?

      Thanks

      Ilonka