Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Modify The Code For Importing Text File into an Excel File | Excel Programming | |||
Importing a file..then saving back to original file | Excel Programming | |||
Importing a file(s) | Excel Worksheet Functions | |||
Importing a file | Excel Programming | |||
Importing text file, only option to edit existing file | Excel Discussion (Misc queries) |