you can't convert to another value.

Best bet insert another row alongside and in [J2] type =I2*100


--
samprince
------------------------------------------------------------------------
samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168
View this thread: http://www.excelforum.com/showthread...hreadid=572269