Thanks for your replies, Rowan's reply seemed the most straight forward
(i'm on nights and brain isnt working too well!) the only problem i
have now is that if i use that formula all my percentages now show as a
decimal i.e 3% is now 0.0314.

Is there a tweak for this?

Thanks again,

Simon.


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=396012