+ Reply to Thread
Results 1 to 2 of 2

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

Hybrid View

  1. #1
    hd
    Guest

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

    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?

  2. #2
    Ron Coderre
    Guest

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

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1