Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is it possible to use Access data w/o importing it? | Links and Linking in Excel | |||
Importing Data from Access | Excel Discussion (Misc queries) | |||
Importing Data from Access | Excel Discussion (Misc queries) | |||
importing data from access | Excel Discussion (Misc queries) | |||
importing data from Access... | Excel Programming |