I am using MsAccess and have some data that I imported from an Excelfile in a table.

How do I convert a short text field with a scientific notation into a text field with a "normal" notation?

The value should be 973185349048.

I have tried, CDbl, Val, Trim but the value is always off.

Thanks

CodePudding user response：

Import as to a (temporary) table having the data type set to Numeric, Decimal and (probably) zero decimals.

Increase the property Precision to, say, 18:

CodePudding user response：

In the original Excelfile the bankaccountnumber has as data type number. On import (via External Data > SavedImports) I change it to LongText. Then the format is as desired (<> scientific notation).

Thanks to Gustav for the help.