If they are in the same column or row, select the column (or row) then
Right-Click
Format
Number
Percentage -- select the number of decimal places you want
OK

Be warned, this method will multiply the values in the cell by 100
first.


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=545750