MrExcel Publishing
Your One Stop for Excel Tips & Solutions

15? 17? Digits of Precision

July 17, 2017 - by Bill Jelen

15? 17? Digits of Precision

Learn about a serious bug in Excel's Calculation Engine. Excel is supposed to use 15 digits of precision. Microsoft is storing 17 digits in the XML, and now a few functions are using all 17 digits, causing calculation anomolies.

Watch Video

Download File

Download the sample file here: Podcast2110.xlsm

Title Photo: elljay / Pixabay

Bill Jelen is the author / co-author of
Excel Subtotals Straight to the Point

I used to use the Subtotals feature daily after downloading mainframe data. This book covers every tip and trick for using Subtotals.