Number Conversion
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 |
All times are GMT +1. The time now is 09:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com