Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I use below expression :-
money(
sum(sales/Rate)
,$#,##0)
it return with 2 decimal point.
May i know how to make it return with decimal point ?
Paul
Is this a typo? Did you put quotes around the format like?
money( sum(sales/Rate) ,'$#,##0')
Is this a typo? Did you put quotes around the format like?
money( sum(sales/Rate) ,'$#,##0')
Try this
=money(sum(sales/Rate),'$#,##0','.',',')
Hi All
Thank you very much , all work.
Paul Yeo