Sorry Bob, the value is assigned to TextBox on the Userform.
The no. is displayed in the TextBox which is to be converted &
formated.
Kindly suggest.
--
Bhuktar S
------------------------------------------------------------------------
Bhuktar S's Profile:
http://www.excelforum.com/member.php...fo&userid=2343
View this thread:
http://www.excelforum.com/showthread...hreadid=264544