I think you need to limit your input to numbers between 0 and 1.0
(100%=1)

Then an entry keyed in as "99" will return 99%

HTH


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=469272