You are both very kind and have provided a solution to my problem that I
consider revolutionary at this point in time (you know how that goes). Thanks
again.
--
David P.


"Pete_UK" wrote:

When you paste HTML into Excel you often get other characters like the
non-breaking space (character 160) in among the digits. Consequently,
Excel will treat the cell as containing text, rather than numbers. You
can do Edit/Replace (CTRL-H) with the cells highlighted, and in the
Find What panel type ALT-0160 (hold down the Alt key and type 0160 on
the numeric keypad) and leave the Replace With panel blank, then click
Replace All.

If that doesn't convert them to numbers, then you can try multiplying
by 1 - enter 1 into a blank cell somewhere, select that cell and click
<copy. Then highlight the offending cells and Edit | Paste Special |
Multiply (check) then OK and <Esc.

Hope this helps.

Pete

On Aug 6, 11:18 pm, David P. wrote:
Does anyone else do this but me? I am pasting HTML perfectly fine into Excel
but the numbers being pasted cannot be calculated. It's almost as if they are
being pasted in some weird format. The format says general but it isn't
acting like a general format. If you have the answer it would be greatly
appreciated.
--
David P.