Couldn't you just format the target cell as Accounting number type?
--
Coolboy55
------------------------------------------------------------------------
Coolboy55's Profile:
http://www.excelforum.com/member.php...o&userid=26508
View this thread:
http://www.excelforum.com/showthread...hreadid=397898