When I import a tab delimited text file into excel one of the fields has a 22
digit number, for example 9101805213907711886715, however when it imports
into excel (even if i cut and paste) it becomes this:
9101805213907710000000. Its putting in zero's after the 15th digit, Ive
formatted cell as text, number etc but nothing works

any help would be appreciated

Thanks