Importing large numbers as text

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!!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top