Remove Scientific Number

[Edward]

I have a list of customers code need to transfer in excel sheet. and there
is a problem when the customer code contain 3E001 and etc.. will
automatically convert into scientific number like 3.00E+01. how can i
disable the feature so that I can get the correct value after import into
Excel.

 

[Jerry W. Lewis]

Either pre-format the cell as text, or prefix the value with a single quote.

Jerry

 

[Jerry W. Lewis]

Are you saying that you are importing a file and the customer codes
import as scientific notation numbers? If so, that was not at all clear
from your original post. For some import formats (such as delimited
text files) you have the option in the Import Wizard to specify that a
particular column is to be imported as text.

Jerry

 

[Tushar Mehta]

Change the Access query to create a text field.