![]() |
convertin html format to number format
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 |
convertin html format to number format
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 |
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 |
All times are GMT +1. The time now is 10:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com