Formatting pasted cells

[Thorbjorn Sundboe]

Hi,

I have pasted data from a webpage into a worksheet. In order to calculate
with it, I need to reformat. I reformat it to "Number" and try to make a
formula, but it does not calculate it. I get a zero as result (not an
error message). I also tried other formats such as general. Any idea what
is wrong?

Thorbjorn

 

[Dave Peterson]

Sometimes extra characters (like spaces and HTML non-breaking spaces) will get
pasted into those cells, too.

David McRitchie has a routine that will clean up this kind of stuff at:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm