The cells are probably text, although they look like numbers and you
formatted them as numbers after pasting them.
Format an empty cell as Number. Enter the number 1. EditCopy. Select your
"numbers". EditPaste special, check Multiply

--
Kind regards,

Niek Otten

"telewats" wrote in
message ...

I've copied information into an excel spreadsheet, and I'm trying to sum
certain columns, however my formula is returning the result of "0". The
column I'm trying to total has numbers such as 2.0, 16.0, etc. so I'm
thinking it has something to do with the formatting in these cells,
however I can't figure out what to do to make it work. Can someone
please help!


--
telewats
------------------------------------------------------------------------
telewats's Profile:
http://www.excelforum.com/member.php...o&userid=30270
View this thread: http://www.excelforum.com/showthread...hreadid=500378