Thanks for your solutions. I will try them. I guess my concern is when I
refresh the data, how will the round function or the refresh function react.
I will try and see. Thanks again!!!

"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!!!