Problem with importing data from text file

[Frederik1234567]

Hey there and Merry Christmas

I need help!

I am trying to import data from a textfile.

The numbers are like this in the textfile.

115,346.248,26,99.9783
120,346.245,26,99.9775
125,346.241,26,99.9763
130,346.222,26,99.9708
135,346.212,26,99.9679
140,346.207,26,99.9665
145,346.202,26,99.9651
150,346.2,26,99.9645
155,346.197,26,99.9636
160,346.195,26,99.963

I am doing a comma separated and tab import.

But the problem is this that the numbers 99.963 is shown as 100, and when I try to plot the numbers they show up like a 100.

So how do I make sure that the data is imported with enought decimals?

Please help me. Thank you.

Regards Frederik.

[rcm]

What method are you using to import the data?

[Frederik1234567]

Data - From text.
Delimited
Tab and Comma
Generel

And I have changed the decimal seperator as dot. My system is danish but the data is from english.

Regards.

[MrShorty]

Are you certain that the data is being converted to exactly 100, or is it merely the effect of number formatting or narrow columns where Excel automatically rounds to the available display space (but the underlying value remains unchanged)?