importing cvs file!!

[kima]

I get some number from a measuring station i a cvs file. But they hav
made a programming fault making some of the negative results arrivin
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

+-------------------------------------------------------------------
|Filename: 205FDB_PROFILE1_20121102060003_003.CSV.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=657
+-------------------------------------------------------------------

 

[Auric__]

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.