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.
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.
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
This topic has been closed to new replies.