View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default convertin html format to number format

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

--


Regards,


Peo Sjoblom

"Sheeloo" wrote in message
...
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.

"abdoulaye" wrote:

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