Insert a 1 in an unused cell. Press <Ctrl<C. Now select the range where
your numbers are not treated as numbers, then right click, select Paste
Special, and tick the Multiply option.

"Craig Fletcher" wrote:

I have some data that I copied out from a webpage (a credit card summary)
which I have since added several other columns around it (i.e., I would much
rather not have to paste it again) and the numbers won't act like numbers.
I've tried copying them out, and doing "paste special" into a new worksheet
with all of the different "paste special" options, and I have also tried all
of the formatting options (currency, numbers, etc.) and still they will not
be treated as numbers by Excel.

Is there anything else I can try?

Thanks,
Craig