Cecil, Next time, try clicking on "Edit|Links|Change Source" and then
browse and select the open workbook to which you copied the formula.
It will convert all of the formulas automatically.


--
Richard9278
------------------------------------------------------------------------
Richard9278's Profile: http://www.excelforum.com/member.php...o&userid=28770
View this thread: http://www.excelforum.com/showthread...hreadid=490005