I get some number from a measuring station i a cvs file. But they have made a programming fault making some of the negative results arriving with "--" instead of "-"

example:

-3.543
0.392
--2.274

This gives problems importing. Resulting in:

-3,543
0,392
2,274

Any ideas how to solve this!!

Have attached the cvs file!!

SOLVED IT … had to import cvs to A:A (TEXT) then Replace "--" with "-" and then use text to columns.

kima wrote:

I get some number from a measuring station i a cvs file. But they have
made a programming fault making some of the negative results arriving
with "--" instead of "-"
[snip]
SOLVED IT … had to import cvs to A:A (TEXT) then Replace "--" with "-"
and then use text to columns.

In the future, just open the CVS file in your text editor of choice and do
the replacing there *before* opening in Excel.

--
So, you're saying that if I can trick all the other mindless drones
into believing that I subscribe to their arbitrary moral framework,
they'll just leave me alone?