With the addition of the percent format, you have to think of your
number as having two additional decimal places (14.102%=0.14102) and
roundup(value,4) or ceiling(value,0.0001)


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=497922