Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Keywords: Large Huge Numbers Float Floating Point Excel Precision Decimal
In order to get the Huge Math extender to return exactly what Excel reuturns you will need to know the settings and limitations of Excel.
Excel stores numeric values as "Double Precision Floating Point" numbers, or "Doubles" for short. These are 8-byte variables that can store numbers accurate to approximately 15 decimal places. You may have only two decimal places displayed on the worksheet, but the underlying value has the full 15 decimal places.
In order to match these results using the Huge math extender you will need to call huge_SetOptions.
AddExtender("WWHUG34I.DLL") UsePrecision = @TRUE ; Fixed precision MaxiDivPrecision = 0 FixedPrecision = 15 AddSeperator = @TRUE SeperatorFormat = @FALSE Decimal = 0 Thousands = 0 ;huge_SetOptions (UsePrecision, MaxiDivPrecision, FixedPrecision, AddSeperator, SeperatorFormat, Decimal, Thousands) a = "38363.99" b = "235313362.64" c = huge_Divide(a, b) Pause('Excel result: 0.000163034','WinBatch result: ': c)
Article ID: W17578
Filename: Huge Numbers and Excel.txt
File Created: 2017:07:28:13:58:30
Last Updated: 2009:10:01:10:57:57