Numeric precision in Microsoft Excel: Difference between revisions

Revision as of 17:53, 23 December 2014

Revision as of 11:36, 9 July 2015

Line 156:

===Accuracy within VBA===

Although Excel nominally works with [[byte|8-byte]] numbers by default, [[Visual basicBasic for applicationsApplications|VBA]] has a variety of data types. The ''Double'' data type is 8 bytes, the ''Integer'' data type is 2 bytes, and the general purpose 16 byte ''Variant'' data type can be converted to a 12 byte ''Decimal'' data type using the VBA conversion function ''CDec''.<ref name=John_Walkenbach>

{{cite book |title=Excel 2010 Power Programming with VBA |chapter=Defining data types |pages=198 ''ff'' and Table 8-1|isbn=0-470-47535-8 |author=John Walkenbach |year=2010 |publisher=Wiley |url=http://books.google.com/books?id=dtSdrjjVXrwC&pg=PA198}}