Numbers import as Exponential

greenfish · May 7th, 2004, 09:37 AM

Help, Help...
When importing data from an Excel spreadsheet into Access 2000 some of the data in one field changes the number formatted in Excel as a category:Number, Decimal:0 ( use this format in Excel to get around the field changing some cells to scientific "e+") shows as a scientific number. This field contain numbers letters and characters, which I have no control over.

EXample: This number in Excel:51268600024353
Will change to: 5.1268600024e+013 when imported into Access
I need it stay as 51268600024353
The box is grayed in the wizard that allows you to indicate the field type.

Steven · May 10th, 2004, 07:00 PM

The numbers are the same, regardless of how they are displayed.
They get stored the same way.
So for any reporting or querying etc, you can then format the number however you like.
For example

Code:

SELECT Format(YourDate, "Fixed") As FormattedNumber FROM YourTable;

I am a loud man with a very large hat. This means I am in charge