Last Digits Are Changed to Zeroes When Entering Long Numbers in Excel 

nnn

Microsoft Excel Tips and Tricks

nnIn this video I explain how to solve a problem where Excel automatically changes the last digits of long numbers to zeroes. Beyond the first 15 digits Excel automatically converts digits to zeroes. The solution to this is to store numbers as text.nnnn

Credit Chester Tugwell

n