4 Replies Latest reply: Jul 25, 2012 4:14 AM by Jérémy George RSS

    Number format: what is the difference between the num and num# functions?

    Jérémy George

      I cannot understand the difference between the num and num# functions.

      The documentation says:

       

      The num function formats the expression numerically according to the string given as format-code. Decimal separator and thousands separator can be set as third and fourth parameters. If the parameters 2-4 are omitted, the number format set in the operating system is used.

       

      and

       

      The num# function evaluates the expression numerically according to the string given as format-code. Decimal separator and thousands separator can be set as third and fourth parameters. If the parameters 2-4 are omitted, the default number format set by script variables or in the operating system is used.

       

      Could somebody explain the difference in a clearer way?