Excel can't handle number bigger than 15 digits. What happens with the VALUE function is that the text is changed to a number, which then breaches this limit, so all digits after the 15th are changed to zero.
So, VALUE is no good.
Chat Forum
[closed]
Sorry, my turn for an Excel query
-
Posted 2 years ago #
-
you see what you need is to use some other form of counting system than binary. like, maybe decimal or something - someone might even have invented it already though
Posted 2 years ago #
Topic Closed
This topic has been closed to new replies.
