Import txt file - problem with long numbers 1

[Flippertje]

Hello all,

i'm trying to import a textfile (commaseperated). The first column contains numbers with 12 digits (eg 105001514536)
When i import these numbers the are transformed to eg 1,050015E+11
When i use the standard format the numbers are rounded to 105.001.500.000
Does anyone know how to import the numbers without them getting rounded?

Many thanks!!!!

Flippertje

 

[SkipVought]

Hi,

Are these "numbers" going to be used in mathematical calculations, or are they like employee numbers, part numbers, invoice numbers -- IDENTIFIERS?

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[Flippertje]

they are identifiers. I will not use them as numbers...

 

[PHV]

So, import these "numbers" in a Text(12) field.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886