csv import

  • Thread starter Thread starter Les
  • Start date Start date
L

Les

I have a csv file that I would like to import to a
waiting worksheet with formulas already in it. I have 2
problems, the figures are not recognised as numerical
when using the sum if function and the csv file is not in
the fomat I would like. If I could attach the file I
could show you, can anyone help?
 
Les,

<<I have 2 problems, the figures are not recognised as numerical >>

Sometimes the data comes across a bit dirty. I often find this when copying
in data from the web. Examine your "numbers" closely. You might have some
extraneous characters. I sometimes must use "left" or "right" to strip away
unwanted characters. Have a look at the text functions, and then examine
your data. If you highlight one of your "numbers", then go to the formula
bar and see if there are other characters present. Highlight everything in
the formula bar and press F9. You should see if there are spaces and/or
other characters present. It just takes a bit of fiddling.

With regard to formatting, you can reformat, or even write a macro to
automatically reformat your worksheet.

Hope this helps.

Regards,
Kevin
 
Back
Top