HTML to Excel

[Guest]

I have saved an HTML document as an Excel document. I am trying to insert a
formula that uses the some of the figures listed on the excel document, but
the formulas return a #value! error. Is this because the figures that were
once html are now not recognized in excel? Formatting the figures does not
work, but if I retype the figure, the formula works. Any suggestions??

 

[Frank Kabel]

Hi
try:
- copy an empty cell
- select your imported numbers
- goto Edit - Paste Special and choose 'Add'

 

[Guest]

That suggestion did not work. Any other suggestions?

Hi
try:
- copy an empty cell
- select your imported numbers
- goto Edit - Paste Special and choose 'Add'

 

[Tom Ogilvy]

It works in most cases. Format the cell as numbers or general before doing
it. An alternative would be to edit each cell. The problem is that you
numbers are being stored as text instead of values.

--
Regadrs,
Tom Ogilvy

That suggestion did not work. Any other suggestions?

 

[Dave Peterson]

I'm not sure how you saved the HTML document as excel, but maybe you have some
of those non-breaking spaces in your cells.

David McRitchie has a macro at:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")

And if you're new to macros, you may want to read David's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Guest]

I saved the HTML document as an excel file because I needed the data from the
table in the HTML. I was able to work it out: I had to create a new web
query in Excel and get the data from the url where the HTML was stored. Once
it was imported, the text automatically coverted to numbers.

Thanks to everyone for all your suggestions!

I'm not sure how you saved the HTML document as excel, but maybe you have some
of those non-breaking spaces in your cells.

David McRitchie has a macro at:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")

And if you're new to macros, you may want to read David's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm