Hi im new at this forum but i hope this is helpful.

try double checking checking the cell format used. if there is nothing
wrong with that (i.e. amounts should be in general or number format and
not text)
try inserting a row on top of the list.
type "1" on th first row and copy it.
highlight the rest of the data and right click -- Paste Special --
Poeration --Multiply.

It should work provided there is no other errors.


--
Eladamri
------------------------------------------------------------------------
Eladamri's Profile: http://www.excelforum.com/member.php...o&userid=35099
View this thread: http://www.excelforum.com/showthread...hreadid=548548