Thanks bob, but Q3 is the result of another look up and calculations so
is definitely not text.
and the amended formula did nothing

Thanks anyway

Andy


--
andyell
------------------------------------------------------------------------
andyell's Profile: http://www.excelforum.com/member.php...o&userid=35272
View this thread: http://www.excelforum.com/showthread...hreadid=560486