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

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

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,095,971
Messages
5,447,598
Members
405,458
Latest member
newbie111

This Week's Hot Topics

Top