Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want to display 99.996817129 to 99.99 in text object how to achieve this?
Try: floor(Number, 0.01)
- Marcus
=Num(value,0.00)
=floor(99.996817129,0.01)
=floor(99.996817129,0.01)
Hi Nilanjan, for text boxes it is helpful to use the num function. The above solutions are correct but if you want to make sure you always format the number correctly you can wrap it in the num function as follows:-
=num(floor(99.996817129,0.01),'# ##0.00')
You can then use any number format for the way you want to display the number.
99.996817129 rounded to 2 decimal places will round to 100.00, not 99.99
If 99.99 is what you want you will need to explain how you came to that number - it is not just rounded.