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...
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!