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