Convert HTML to number
I have found a table on the web that I would like to use in Excel. If I copy
and paste it into Excel as HTML, it fits into the celss just fine, but I
can't do any calculations on it. If I paste it as text (Unicode or not), it
all squishes into column A. How can I change the format of the cells so that
calculations can be performed? Doing the usual Cell Format stuff doesn't
work.
Thanks.
|