0 Replies Latest reply: Aug 6, 2018 5:54 AM by Ching-Min Chen RSS

    Number formatting

    Ching-Min Chen


      I want to ask a feature where i can change the display of large numbers between T to omit "000" at the end and M to avoid "000 000" at the end of the displayed number


      For example wenn the number is 10,000 it will display 10T, and if the number is 10,000,000, it will be showed as 10M.


      I have selected “cusom” under Number formatting with format pattern #.##0M. For it doesn’t turn to 1.000M but

      Could anyone tell me how to solve it.


      With many thanks.Capture2.PNG