Number Conversion

[Guest]

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]

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()")

 

[Guest]

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