MS Access - Linked sheet - Scientific notations

[subhanak]

Hello,

I have an excel spreadsheet which is linked to and access database.

One of the fields consists of the waybill number. The values of this given field consist of alphanumeric values(1ZA999999999999999), and long numbers convert it into scientific notations (5.99991E+11).

Waybill number
1ZA392322019999999
1YA392322018999999
5.8003E+11
9.99999E+11

When I open the linked sheet into access the last digit of the numbers formatted as scientific notation is converted into zero.

Is there any way to solve this hurdle?

Your assistance is appreciated.

Thanks,
Sayed

 

[Marbles]

It should probably be a text field.

 

[subhanak]

It should probably be a text field.

Actually, it is a text field.

THnaks,

Sayed