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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Sum infinite formula 7
Addition errors with Decimal Places 5
eliminating decimal places 4
Rounding to two even decimal places 3
Access stripping decimal places in query 1
3 tier incentive matrix w/ infinite possibilities 7
How do I get Rid of the Circumflex Accent (Caret) 2
Determine decimal 5

Back
Top