formatting number in csv file import. Number being rounded / decimnal places truncated

[DocAElstein]

Hi

The numbers appear to be imported correctly.
I looked in your .csv text file :
https://excelfox.com/forum/showthrea...ll=1#post15602
https://excelfox.com/forum/showthrea...ll=1#post15603
https://i.imgur.com/PgEalNM.jpg
LargeNumbersImportedCorrectly.JPG
_____ Workbook: apvtrn.csv ( Using Excel 2007 32 bit )

Row\Col	DI
1	PY00000000000000004918
2	4.00E+11
3	PY00000000000000005064
4	4.00E+11
5	PY00000000000000005149
6	4.00E+11
7	PY00000000000000005260
8	4.00E+11
9	PY00000000000000005453

Worksheet: apvtrn

There are no numbers like "400003395647"

If you have a text file with data that cause the problem, please gives us a sample of that. ( Remember to please keep the sample file size small - we only need 2-3 lines of data in order to investigate the problem. But the data must be chosen so as to demonstrate the problem )

Alan