# 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 Posts: 5,377, Reputation: 5036 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.

## Check out some similar questions!

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 mischeivous person turns the sign upside down. I find out that new number is 720 less than the old one. What was the orginial number?

find the integer

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