14 Replies Latest reply: Aug 2, 2017 1:17 PM by Sunny Talwar RSS

    Display decimals without condensing or trailing zeros

    Philip Zeiser

      Without formatting, numbers are condensing after 5 decimal places.

       

      Decimals Condensed.PNG

       

      Now I can format this to show all the numbers formatted to 10 decimal places, but I don't want the trailing zeros.

       

      Decimals Trailing Zeros.PNG

       

      Is it possible to do this with only formatting functions? I'd rather not use string functions to remove the excess zeros.

       

      =ValueLoop(1,10)Desired Result
      10.1
      2

      0.01

      30.001
      40.0001
      50.00001
      60.000001
      70.0000001
      80.00000001
      90.000000001
      100.0000000001

       

      Thanks.