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