Are you formatting the column the numbers are being imported into? Number and 2
decimals?
: Nick:
: Thanks for this information but I entered the numbers
: into Access and they only have 2 decimal places but when
: the get into Execl, whether by export from Access or
: using the Import External Data function in Excel I get
: the extra previously nonexistant numbers. For example I
: have entered 18.30 into the Access data base and Excel
: imports 18.2999999902 or 35.10 and I get 35.099998. I
: have tried this with another program, SPSS, and the
: numbers are imported correctly.
:
: What do you think?
:
:
: >-----Original Message-----
: >Michael
: >
: >Excel cannot make these numbers up. The truth is
: probably...
: >
: >Access has a number formatted to two decimal places so
: you see 1.50 in
: >Access where actually Access is holding 1.49567892 (or
: similar) and the
: >formatting gets lost en route
: >
: >--
: >HTH
: >Nick Hodge
: >Microsoft MVP - Excel
: >Southampton, England
: >
[email protected]
: >
: >
: >: >>I have exported and imported a data set from Access.
: >> Excel insists on adding decimal places and putting
: >> numbers in that do not exist in the Access data base.
: >> How do I stop this from occurring?
: >
: >
: >.
: >
