1 Reply Latest reply: Apr 5, 2012 10:31 AM by M Woolf RSS

    Number format

    Badr Harfoush


      I am using the follwing formula to format a nr :

      =num(sum(SALESPRICE),'$#,##0')..it returns for example 2,354,874

      How can I get rid of the hudreds  and round it as well. so it returns 2,354..