When exporting from Access to other MS applications, why is 10.3 .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When exporting from Access to an Excel file, a number like 3024.3 in Access
is turned into 3024.300049 in the Excel spreadsheet and it does it only to
some of the records. It also does it when merging data from Access to a Word
document (again only sometimes).
 
It's the "vagaries" of floating point numbers... they are not exact numbers
and can cause those "far to the right" extra decimal places.

If you know that you want a specific number of decimal places, then use a
query to export the data, and use a calculated field in place of the actual
number field, where you use the Format function to explicitly state the
number of decimal places that you want:

MyOutputNumber: Format([MyFieldName], "0.00000")

The above will export the number with 5 decimal places.
 
Back
Top