1 Reply Latest reply: Apr 5, 2012 10:31 AM by mike woolf RSS

    Number format

    Badr Harfoush

      Hi

      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..

      Thxs