Hi

They are text strings - not numbers.

Set the cell format for range with imported data to General or to Numeric.
Copy a number (NB! A number!) 1 (or 0) from elsewhere.
Select the range with imported data, and then PasteSpecial.Multiply
(PasteSpecial.Add) - press OK


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)


"Dennis" wrote in message
...
This is strange. Occasionally when I paste numers from the web and say I
select 3 cells with numbers in them they wont total down in that Auto Sum
area
on the bottom right. Also a =SUM wont work for those cells. But if I
retype
over them then it all works fine. Any ideas?

TIA Dennis
=========