Thanks you two guys. Yes, you are right but doesn't it seem odd that a
text manipulation function doesn't work with a result field
pre-formatted as text!?
John


--
jbenet
------------------------------------------------------------------------
jbenet's Profile: http://www.excelforum.com/member.php...o&userid=29531
View this thread: http://www.excelforum.com/showthread...hreadid=492297