Ask Experts Questions for FREE Help !
Ask

by increasing indent in excel with seventh digit shows integer

Asked Jun 29, 2012, 12:36 AM — 1 Answer
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.

Search this Thread
Share |
1 Answer
JBeaucaire's Avatar
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.
Helpful
Not your question? Ask your question View similar questions
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Add your answer here.

Remove Text Formatting
 

Undo
Redo
  
Decrease Size
Increase Size
Bold
Italic
Underline
Align Left
Align Center
Align Right
Ordered List
Unordered List
Decrease Indent
Increase Indent
Insert Email Link
Wrap [QUOTE] tags around selected text
Wrap [CODE] tags around selected text
Wrap [HTML] tags around selected text
Wrap [PHP] tags around selected text
Wrap [YOUTUBE] tags around selected text
Notification Type:



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 mischeivous [ 0 Answers ]

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?

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 Spreadsheets questions Search