convertin html format to number format

  • Thread starter Thread starter abdoulaye
  • Start date Start date
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
 
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.
 
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
 
Back
Top