Ask Experts Questions for FREE Help !
Ask
    wesmar's Avatar
    wesmar Posts: 1, Reputation: 1
    New Member
     
    #1

    Oct 2, 2013, 09:59 AM
    Rounding long decimal numbers
    Im trying to put in a formula in excel to divide two numbers... but when I get my long decimal number I want to shorten the answer
    pready's Avatar
    pready Posts: 3,197, Reputation: 207
    Ultra Member
     
    #2

    Oct 2, 2013, 10:54 AM
    On the Home screen in your Workbook on the top in the middle there should be a Number dropdown box. Below this dropdown box there will be 4 icons. The icon on the right is to decrease the decimal. Just click on the Decrease Decimal box until you get the right number of places.

    The box just to the left of the Decrease Decimal Box is the Increase Decimal Box.
    Kevin-Radstock's Avatar
    Kevin-Radstock Posts: 8, Reputation: 3
    New Member
     
    #3

    Oct 4, 2013, 09:46 AM
    Hi

    You can use the ROUND function, for example.
    =ROUND(A1/A2,2) which will round to 2 decimal places.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #4

    Oct 4, 2013, 02:02 PM
    Definitely use the ROUND() function in your formula as that will create an actual decimal value that is under your control. If you use the suggestion in the first reply you'll still have long decimals hidden behind short formatting, not nearly as good.

    For instance:

    =A1/B1

    Is better as:

    =ROUND(A1/B1, 2)

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Rounding numbers and something else [ 2 Answers ]

Help please, View Image, http://www.pttbn.com/media/downloads/1.png Thanks

Rounding numbers and something else [ 2 Answers ]

Help, please, View attachement. Thanks

Rounding numbers [ 2 Answers ]

2,782 rounded the highest

Rounding numbers [ 2 Answers ]

What is 12.17556 to the nearest ten-thousandth?


View more questions Search