Sub change_test ()

if range("C4").value = "1" then
range("E4").numberformat = "0.00%"
if range("C4").value = "2" then
range("E4").numberformat = "$0.00"
end if
end if

end sub

that should work..

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=48102