Importing Access data

[fernando]

Hello,

I am importing data from an access table. Everything
works fine, but when working with numbers with decimals
(0.0 to 1.0), strange things happend. For example

Access = imported to excel datasheet
0.1 = 0.100000001490116
0.2 = 0.200000002980232
0.3 = 0.300000011920929
0.4 = 0.453000009059906
0.5 = 0.5
0.6 = 0.600000023841857
0.7 = 0.699999988079071
0.8 = 0.800000011920928
0.9 = 0.899999976158142

This is very strange to me because this numbers are
intoduced by the user, they are NOT result of any
calculation.

I don't know if this is an Access or Excel question, but
any help is appreciated

Thanks
Fernando E

 

[Greg Koppel]

Hello Fernando,

Those numbers are a result of the binary conversion by Excel. I think if you
go to Tools/Options/Calculation/Workbook Options, and check the box for
Precision As Displayed, your problem will go away.

HTH, Greg