How to make it return with out decimal point ?

[paulyeo11]

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

[tresB · Accepted solution]

Is this a typo? Did you put quotes around the format like?

money( sum(sales/Rate) ,'$#,##0')

[kamal_sanguri]

Try this

=money(sum(sales/Rate),'$#,##0','.',',')

[paulyeo11]

Hi All

Thank you very much , all work.

Paul Yeo