you've got numbers stored as text.

put the number 1 in a cell. copy the cell, highlight the range of
numbers stored as text and right click. paste special-multiply


--
MDubbelboer
------------------------------------------------------------------------
MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330
View this thread: http://www.excelforum.com/showthread...hreadid=562636