News for hackers. Stuff that matters.

A comment on Excel will allow certain auto data conversions to be turned off. Parent comment

Re:Excel will allow certain auto data conversions to be turn... by rzzzt on Monday October 23, 2023 @04:55PM (#37991467)
I would like to store, then retrieve exactly 1234567890123456789 apples instead of 1.070816993713379 × 2⁶⁰ = 1234567939550609408. Unfortunately due to IEEE-754 conversions I can only do this up to 7-8 digits or so. This is a number, just not one that can be represented as a Number without loss of precision towards the end.
[ Parent | on HN ]
Re:Excel will allow certain auto data conversions to be turn... by master-lincoln on Tuesday October 24, 2023 @05:41AM (#37996753)
that's more apples than we can fit on the planet. For such special tasks I would think it's ok to need special tools
[ Parent | on HN ]