Problems calculating a converted html table to Excel XP (2002)

N

New Excel XP User

I have a generated report off the web that must be converted into Excel. When the report comes up initially it is in a .asp format. I save the report off the web in HTML format. Then open excel, then go to file -> open and browse for the file that I just saved.

The report opens fine with all data showing up as is. However when I try to go and calculate a column of numbers, the answer that I get is 0. So if I go and add up say this list of numbers which is : 5, 7, and 8. The sum should be 20. Instead I get 0 everytime. I have tried to format the cells to be numbers instead of general.

I have checked to make sure that the worksheet is not protected. This report used to work in Office 97 SR2. The version of Office XP that I have is Office XP SP3

If there are any ideas, I am willing to listen

Thanks

New Excel XP User
 
K

Ken Wright

Your data is being returned in text format, and simply using the format menu to
make them numbers will not work. What you will likely find is that if after
using the format menu, if you now select each cell in turn and hit F2 and enter,
the data becomes numeric, but you don't want to spend all that time doing it
that way.

Format any single cell as numeric and then enter a 1. As long as it right
aligns you should be OK. Now copy that cell, select all your data and do Edit /
Paste Special / Multiply, and this should then coerce the data back to numeric.
Now try your SUM.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :)
----------------------------------------------------------------------------



New Excel XP User said:
I have a generated report off the web that must be converted into Excel. When
Click to expand...
the report comes up initially it is in a .asp format. I save the report off
the web in HTML format. Then open excel, then go to file -> open and browse for
the file that I just saved.
The report opens fine with all data showing up as is. However when I try to
Click to expand...
go and calculate a column of numbers, the answer that I get is 0. So if I go
and add up say this list of numbers which is : 5, 7, and 8. The sum should be
20. Instead I get 0 everytime. I have tried to format the cells to be numbers
instead of general.
I have checked to make sure that the worksheet is not protected. This report
Click to expand...
used to work in Office 97 SR2. The version of Office XP that I have is Office
XP SP3.
 
N

New Excel Xp User

I just tried your suggestion. Still the sum is equal to 0. All the cells currently in the column are now set as Number. The cells were formatted in general format.
 
Top