This sounds as if they are being pasted as text, not numbers. When you type
them, they are then input as numbers.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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
=========