Importing large numbers as text

  • Thread starter Thread starter GD
  • Start date Start date
G

GD

I'm trying to import a text file containing an invoice # field into a table.
This Inv# field needs to be formatted as text, because some of the invoice #s
contain letters & numbers.

However, others are numbers only and a few are very large numbers, like:

2698356000000

The problem is that it is being imported as:

2.69836E+12

How can I get these large numbers to be imported as text, but as is??

THANKS!!!!
 
Back
Top