Linked Excel Table Showing Wrong Value

[lukejc1]

I found this problem with one of my linked excel tables. The value in the table is 1.4707 in excel, but when I look at the table in Access 2010 it show as 1.4706. I don't think this is a rounding issue because the value was entered as 1.4707 and doesn't come from a formula.



This happens whether the table is linked or imported.


Any ideas as to what might cause this and how to fix it?


Thanks,


Luke

[lukejc1]

I already found the issue. I had the cell properties in excel set as "currency." I changed it to "general" and the problem is fixed.