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 exponential value was altered (bellow).
| 3,03E+06 |
Does anybody know how to solve this? I tried many options of copy (from a table of a docx file) and import directly from a txt file. On the conversion windows of the txt files the numbers are OK but when I conclude the procedure all the exponential numbers are altered. Thanks.
9 Replies
José Maurício Gonçalves dos Santos
If you want to import a batch of numbers without changing your system settings you could bring them into a text-formatted range. The use SUBSTITUTE to remove any English thousands separators "," (if any exist) and replace the decimal point "." by the character used by your machine locale (presumably ",").
Coerce the formula to a number by preceding it with --.
= --SUBSTITUTE( SUBSTITUTE(numbers, ",", ""), ".", ",")Not very nice at all, but better than retyping numbers!
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
