6 Replies Latest reply: Nov 7, 2017 8:40 AM by Manuel Tertre RSS

    Formatting numbers with currency

    Manuel Tertre

      Hello, I'm having trouble representing numbers in french format. What I actually want to do is to have thousands separated by spaces, up to 2 decimals separated by a comma and a euro sign at the end separated by space ("2 845,99 €" e.g.).

       

      I know how to do some of these things but not how to combine them :

      To have spaces between thousands, I use the formula "# ##0" with "," as decimal separator and " " as thousands separator.

      To have up to 2 digits after the comma and the euro sign, I use the expression "Round(mynumber,0.01)" and the formula "0,################ €" with the same separators.

       

      I don't know how I can combine both to do what I want, do you know how I could do it ?