Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to make it return with out decimal point ?

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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

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

View solution in original post

3 Replies
tresesco
MVP
MVP

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

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

kamal_sanguri
Specialist
Specialist

Try this

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

paulyeo11
Master
Master
Author

Hi All

Thank you very much , all work.

Paul Yeo