HTML to Excel
 

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??
--
Many Thanks,
Paula

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Billing Goddess" schrieb im
Newsbeitrag ...
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??
--
Many Thanks,
Paula

That suggestion did not work. Any other suggestions?

"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Billing Goddess" schrieb im
Newsbeitrag ...
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??
--
Many Thanks,
Paula

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

"Billing Goddess" wrote in
message ...
That suggestion did not work. Any other suggestions?

"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Billing Goddess" schrieb im
Newsbeitrag ...
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??
--
Many Thanks,
Paula

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

Billing Goddess wrote:

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??
--
Many Thanks,
Paula

--

Dave Peterson

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!

"Dave Peterson" wrote:

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

Billing Goddess wrote:

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??
--
Many Thanks,
Paula

--

Dave Peterson