Importing large numbers as text

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

--
GD

Never mind! My text was screwed up.
--
GD


"GD" wrote:

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