Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=num(floor(sum(SALESPRICE)/1000),'$#,##0') would return 2,354
=num(floor(sum(SALESPRICE)/1000),'$#,##0') would return 2,354