Excel: How to Prevent Excel Replacing Last Numbers with Zeros
You typed a long number into a cell, say a ProductID that was 20 digits long. Excel has replaced the last 5 digits with zeros. What gives?
Excel can't store more than 15 digits per cell. When a number that is larger than this is entered into a cell, Excel stores the first 15 digits and replaces all remaining digits with zeros. In this video I’m going to show you how to fix this issue
🗒 Notes and Resources
Download a copy of the file used in this video: https://app.box.com/s/fcc97obw55m601m...
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #15digits #numbersreplacedwithzeros