SOLVED importing cvs file!!
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.
Last edited by kima : November 5th 12 at 12:37 AM
|