convertin html format to number format

A

abdoulaye

I want to convert data in html format into numebr format. I copy them from a
web page and paste them on an excel sheet, but the initial format (html)
remains. How to convert the format?
Thanks
 
S

Sheeloo

I pasted the date on youu post to Excel without any problem...

Try Paste Special and choose Text...
If this does not solve your problem then paste a sample of what you are
getting here so that we can suggest something.
 
P

Peo Sjoblom

Another way if the data is similar to a table would be to do data>import
external data and new WebQuery. That way there are never any problems with
the formats

--


Regards,


Peo Sjoblom
 

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

Top