I'm working on a spreadsheet where my formula answer is an infinite number.
How do I round my number and permanently get rid of the infinites so when I
copy and paste the values I don't have a million numbers?
I'm working on a spreadsheet where my formula answer is an infinite number.
How do I round my number and permanently get rid of the infinites so when I
copy and paste the values I don't have a million numbers?
I can think of 2 ways:
Tools>Options>Calculation
Check Precision as displayed
(I'd make a back-up before using that one, just in case)
OR
Wrap your formula in the ROUND function:
from =1/3 -------> 3.33333333333333
to =ROUND(1/3,2) --->to round to 2 decimal places --> 3.33
--
Regards,
Ron
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks