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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

jmacleary

Well-known Member
Joined
Oct 5, 2015
Messages
941
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,096,455
Messages
5,450,564
Members
405,617
Latest member
Passi

This Week's Hot Topics

Top