Re: I don´t view the value right after six decimal place in Excel

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You have reached the limit of precision available in Excel. The decimal place has no bearing on this, if you add 10000 to the number the last 7 will become a Zero too, and then it would be after the fifth. There is only 15 significant digits available, after that zeros only.

Claudio wrote:

'Not that this is happening with me after the sixth decimal place has only zeros. How to reach us below after the sixth decimal place?

"Bob I" wrote:


Actually Excel produces

2137,63308348257

as opposed to

2137,6330834825731

which is due to the limit of precision available in Excel.

Claudio wrote:


This problem also occurs in Excel 2007.

"Claudio" wrote:



Suppose cell A1 = 1,0198424825731 (thirteen decimal places after comma) and cell B1 = 2136,613241 (six decimal places after comma) the result is presented in Excel = 2179,008952 (only six decimal places after comma) and should be presented the following results = 2179,00895199999.

After a six decimal places is presented 000000 (zeros)

"David Biddulph" wrote:



It's no good just saying vaguely: "... are not correct"
Tell us what formula you used, what numbers were the inputs to that formula, what answer you got, and what answer you expected.
--
David Biddulph

"Claudio" <Claudio@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:A28E673E-E717-45B0-8BE7-ED8EF1245ACA@xxxxxxxxxxxxxxxx


Even making calculations only by the Excel submitted figures are not correct

from the 6 decimal place, and I updated with Office (last SP), which can

be?

Other e-mail for contact: claudiop@xxxxxxxxxx





.

Relevant Pages