Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am working with a straight table where i need to round some values from
100,000,000.00 to 100.00
AND
if value is only two decimal palaces 0.11 no action is needed.
How can I work this into a formula?
Thank you
Hi,
Try something like this:
=num(sum(Expression),0.00)
Regards,
-Khaled.
Pl upload the application
Try this
=round(sum(Expression),0.01)
it will round the values and display with 2 decimals
or if u want to list the first 2 decimals.
Goto the properties tab, select numbers theere u can modify the values accordingly..
or =num(sum(Expression),0.01),' #,##0.00') it will exactly return 2 values...
That does not work for me. Any other suggestions?
can u post a sample .so that we can figure out where exactly ur missing?
Dear zvirina123,
in the stright table goto Numbers tab and select the Particular expression and in the number format settings select the fixed to 2 decimal.
Thanks,
Mukram.
Here you go. Thank you for your help
where exactly ur getting wrong..
i am able to display for the 2 decimals..
the thing is u marked in numbers as money format..
can u change that to decimal...
Now i am getting extra zeros. How can i hide it?