I think it's usually best to clean up the raw data.

You may want to try David McRitchie's routine to clean the data:

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

anandmr65 wrote:

Hi,

I have a column that should have numbers. I copy the data from some
html source to excel. When the data is copied the numbers are treated
as text and the numerical functions such as SUM does not work & even in
pivot tables the sum etc. are not working. I tried to convert these to
numbers using value(0 function, but gives a formula error (#name etc.)
cold somebody suggest a way to tackle this problem. I tried copying the
complete column to another sheet & back but it still remails as a text.

Please help

Thanks
Anand

--
anandmr65
------------------------------------------------------------------------
anandmr65's Profile: http://www.excelforum.com/member.php...o&userid=30728
View this thread: http://www.excelforum.com/showthread...hreadid=507118

--

Dave Peterson