1 Reply Latest reply on Mar 1, 2017 10:02 PM by Chris McClellan

    1,000s

    Eric Tang

      Hi,

       

      Does anyone know if there is a way to change the units of measure from K to M to denote 1,000? I work in an industry that uses M as '000s and MM as '000,000s.

       

      Eric

        • 1. Re: 1,000s
          Chris McClellan

          You will need to set your number format to Custom,

           

          use this for '000 and M #,##0,.00M;-#,##0,.00M

          use this for '000,000 and MM #,##0,,.00MM;-#,##0,,.00MM

           

          but do you want to do both at the same time automatically ?

          1 of 1 people found this helpful