Downloading ebay generated .csv files into excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When i download an ebay generated .csv file into excel it downloads numeric
fields as text fields (values perfixed wth $ and EUR). This means I cannot
manipultate the numeric information i.e. sum etc (values prefixed with £
remain as numeric values).

How do you convert a text field into a numeric one without overwriting each
cell with the value!!!!!

Kind regards
 
How about just selecting the range
edit|replace
what: (whatever character(s) you want to get rid of)
with: (leave empty)
Replace all
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell format on reading .csv file 3
CSV->Excel Data Problem 1
How to Export Gmail Emails to PST Format? 4
How to open a csv file without auto converion 2
CSV file doesn't save "xEy" style number as text formatted data 1
Excel CSV Files; Creating Of 3
CSV text data altered on file open 4
excel xls to csv numbers stored as txt lose first 0 1

Back
Top