| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save As HTML Format Issue | Excel Discussion (Misc queries) | |||
| how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
| Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
| HTML Format of Comments Indicator | Excel Discussion (Misc queries) | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
Linear Mode
