I'm sure there are other ways but Excel is using 15 digits wherever it can so
when numbers are a result of calculations they can be v. long. You could
always incorporate the ROUND function somewhere which will force the number
(in a new column) to round to the specified places - this example is 4
places. Then you could use that as a paste special Values if you want to
completely remove the 15 digits for good (or record all that on a macro
maybe)?

=ROUND(A1,4)

this would take contents of A1 and create a new number but rounded to only 4
places - could choose 2 or 6 places etc etc

Sall



"William McNeill" wrote:

I have an Excel spreadsheet and I am importing data into it from Access. for
some reason I have a lot of extra digits added to the number and the nunumber
is also changed slightly. For instance, the number -0.0034 in Access becomes
-0.00340000000000007 and -0.0042 becomes -0.00419999999999998. I have
formatted the cells to show only 4 digits, which it does, but when you have
the cell selected, you can see the very long number in the box. It seems
that Excel is using the long number in instances where I am doing averages
and other functions. What can be done about this? I get new data in Access
weekly and then refresh in Excel afterwards, and I wonder if there is
something that I am doing wrong. Thanks!!!