Last digits are changed to zeroes when you type long numbers in cells of Excel Describes that Excel can store only 15 significant digits in a number. If the number that you type contains more than 15 digits, any digits past the fifteenth digit is changed to zero. Format the number as text to work around this problem.