1 Reply Latest reply: Apr 5, 2012 10:31 AM by Michael 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