How do I get rid of infinite numbers past the decimal place?

H

hd

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?
 
R

Ron Coderre

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
 
Top