View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Craig Fletcher
 
Posts: n/a
Default 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