Forum Discussion
Copy and paste OR import trouble with exponential numbers
Hello, When I copy an number or import a TXT file with an negative exponential number (bellow) to excel 3.03425675881e-05 the number is altered to a positive exponential and even the...
Hi Jose,
I was not able to reproduce it. I copy your number and paste to Excel; when create txt file with it and import - have correct number in both cases
Could you please attach your txt file with few numbers to check?
Dear Sergei,
Thank you for your response. I discovered the problem, I use my computer with a , for decimals and not . as in the american system. When I changed it it works just fine. Best regards.
So far so good, thank you for the update
I am facing the same problem, when I paste
-4.424312e-003 in excel it gets translated to -4.42E3
