cell format: numbers won't be numbers
Also,
I went to that same site and tried the paste again, and noticed that the
format it wants to paste into Excel with is "General".
"kassie" wrote in message
...
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
|