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

    Jun 29, 2012, 12:36 AM
    by increasing indent in excel with seventh digit shows integer
    In excel if I increase the indent more than 7 decimal digits showing the value: 55156180.4400003000000
    but with increasing the indent to only 6 digits shows:55156180.440000

    What could be the reason and how to resolve this issue.
    Request any suggestions.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Jul 2, 2012, 10:51 PM
    I don't understand the problem.

    IF the number is 55156180.4400003000000 and you format that to 6 decimals, the rounding results in 55156180.440000 because the 3 in the 7th decimal isn't high enough to cause it to round up.
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!

Excel 15 digit issue, tried converting to text, text to column feature negates fix [ 6 Answers ]

I have the following numbers that exceed 15 characters that needs to be split into its own columns. Down the road, there would be thousands of such rows of data with the first couple set of unique numbers. 890432453253208820,5004500558,05CC,1,0,0,0,0,0,0, 0000,5.0000,2007-01-11...

My home has a four digit number, none of the digit is repeated, one day a mischievous [ 0 Answers ]

My home has a four digit number, none of the digit is repeated, one day a mischievous person turns the sign upside down. I find out that new number is 720 less than the old one. What was the orginial number?

if the square of a positve integer is added to 2 times the integer, the result is 120 [ 1 Answers ]

find the integer

How to use only integer variables in Solver of Excel 2010? [ 0 Answers ]

I am trying to solve a linear programming problem using Excel 2010. I am new to this so I decided to start with a simple problem. I have put objectives, variables, constraints everything correctly. I am doing it in Simplex method. Solver solves the problem, but with the variables being in decimal...

20 digit problem in excel [ 1 Answers ]

I can not write 20 digit number in a cell of excel 2007.please guide

View more questions Search