when I enter a number that has 16 digits the 16th digit turns to Zero no matter what I enter. Also, any numbers past the 16th digit show zero's
I dont really want to change the format to text ( although that fixes the problem) I would like to keep it in a number format of some kind.
Is there a way to fix this problem?
Your computer only stores numbers to 16 digit precision. For any longer numeric string, you must use text.
Entia non sunt multiplicanda sine necessitate
So the 16th digit itself will always be zero? Because if I use only 15 digits it works fine ... but when I add the 16th that one always turns to zero.
is that correct??
Sorry, 15 significant digits. Double-precision floating point numbers actually have a little better precision than that, but Excel does some cosmetic rounding and never shows more than 15.
It's not really a problem to format these long numbers as text. You can still do math on text strings that appear to be actual numbers.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
But not using precision beyond 15 digits.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks