ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   convertin html format to number format (https://www.excelbanter.com/excel-discussion-misc-queries/202075-convertin-html-format-number-format.html)

abdoulaye

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

Sheeloo

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


Peo Sjoblom[_2_]

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