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

Microsoft Excel Tips and Tricks

In 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.

Credit Chester Tugwell

Please support our Sponsors here :