custom format required is 0"B"

this converts 1.51 to 2 (eg no decimal places) and the B is added on
the end


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=536678