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

kashif.special2005

Active Member
Joined
Oct 26, 2009
Messages
435
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
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

jmacleary

Well-known Member
Joined
Oct 5, 2015
Messages
942
Office Version
2007
Platform
Windows
It sounds like the format property of the field in Access is set to Scientific. Try setting it to General.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,166
Messages
5,467,014
Members
406,518
Latest member
SilverSixx

This Week's Hot Topics

Top