I am importing data from a text file. One of the fields is an account number. The account number is 12 digits in length. I use the double field size when defining the file using the import wizard. When I view the table, the account number is displayed with an exponent (E11) and I do not want it to do this. If the account number is 500000004316, the table has 5.00000004316E+11. The text file has the full account number without the E. Any suggestions would be appreciated.
