Ask Your Question

How can I enter 41982.7500663774408167 with all decimals

asked 2015-01-27 10:36:02 +0100

wibek gravatar image

When I enter 41982.7500663774408167 in a cell, the result is 41982.75006637744000000. Completely useless. How can I keep all decimals?

(calc v

edit retag flag offensive close merge delete


Sorry, you can, but Calc cannot. Calc can save 15 digits only

JohnSUN gravatar imageJohnSUN ( 2015-01-27 10:48:37 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2015-01-27 10:52:21 +0100

Nicd gravatar image

You have exceeded the amount of digits a double can store (decimals are usually stored as doubles on a computer).

You can preced the value with a ', which will make it be interpreted as a string (a series of characters). It will enable you to store the whole value, but you cannot do calculations on it.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-01-27 10:36:02 +0100

Seen: 74 times

Last updated: Jan 27 '15