I copied a table of number from the web into Excel but I can not do basic
functions with the numbers. Is there some quick way to convert all of the
numbers?

Thank you in advance

Richard

David McRitchie has some code that will help clean this stuff up:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")

Richard wrote:

I copied a table of number from the web into Excel but I can not do basic
functions with the numbers. Is there some quick way to convert all of the
numbers?

Thank you in advance

Richard

--

Dave Peterson

Dear Richard
After copying Please try to paste in a different way:
when pasting in Excel go to
EDIT Paste Special Values

and then perform function you want to.
Hope this will help you

"Richard" wrote:

I copied a table of number from the web into Excel but I can not do basic
functions with the numbers. Is there some quick way to convert all of the
numbers?

Thank you in advance

Richard