2 Replies Latest reply: Feb 20, 2012 1:48 PM by Stefan Wühl RSS

    Formatting Numbers

      Dear community,

       

      i'm very embarassed to ask, but is it somehow possible to format numbers in this way:

      Step1: 14960

      Step2: 14.960

      Step3: 14 TEUR

       

      Step1 to Step2 is easy. But i totally fail at Step3. :-(

       

      How can i do that?

       

      Regards,

      donuteater

        • Formatting Numbers

          Obviously, i'd format it in Excel like this

           

          "#.##0."

           

          But this doesn't work, since it does seriously destroy the whole format of the number.

           

          :-)

            • Formatting Numbers
              Stefan Wühl

              In your format, you are using two times the 'dot' I suppose you want to use one time dot and one time the comma as thousand resp. decimal separator?

               

              So, a full format might look like:

              =num(14960,'#.##0,0',',','.')

               

              or without the decimal separator:

              =num(14960,'#.##0',',','.')

               

              and if you want to get to step 3:

              =num(14960/1000,'#.##0',',','.')&' TEUR'

               

              or without rounding:

              =num(floor(14960/1000),'#.##0',',','.')&' TEUR'

               

              Use all these expression e.g. in a text box, and you could also replace the 14960 constant with a field name.

              =num(floor(FACTFIELD/1000),'#.##0',',','.')&' TEUR'