Double data type field's value showing with E-02 value

[kashif.special2005]

Hi,

I have data in excel and one field in excel value is showing like (0.0816901332227654), and when I paste this data in a Access table the data is showing is like this (8.16901332227654E-02), the number should show in Access as showing in Excel.

I don't know how can I fix it, pleas help me resolve this problem.

Thanks
Kashif

 

[jmacleary]

It sounds like the format property of the field in Access is set to Scientific. Try setting it to General.