Ask Your Question
0

How can I enter 41982.7500663774408167 with all decimals

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

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 4.2.6.3)

edit retag flag offensive close merge delete

Comments

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

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

1 Answer

Sort by » oldest newest most voted
2

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

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

Stats

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

Seen: 55 times

Last updated: Jan 27 '15