Values change when I open an .asc document

[Ariespek]

When opening an .asc document, its not opening te normal way, but you can divide the text in different cells.
But when I do this the values change, but why?


[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"] +8.0032788e+03 +7.9059053e+03 +7.8009893e+03 -8.9554429e-02 +3.3130959e-02 [/TD]
[/TR]
</tbody>[/TABLE]

These values change to:

[TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]8,00E+10
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]7,91E+10[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]7,80E+10[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]-8,96E+05
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]3,31E+05[/TD]
[/TR]
</tbody>[/TABLE]

How is this possible or how can I fix this?

 

[pgc01]

Hi
Welcome to the board

From what I read, you have 2 different meanings for the delimiters, which is a good recipe for disaster if you don't take care.

In one case the decimal delimiter is the comma and in the other one it's the dot.

Make sure it's coherent. For ex., if you are using the comma as the decimal delimiter then edit the text file and replace the dots by commas, or vice-versa.

If you don't want to change the source, import the file as text, you'll get an import dialog, like in the text-to-columns, and you can change the meaning of the delimiters in the third panel.