Hi Norman,

Thank you for the help mate. It worked perfectly. The other method tha
worked for me was to setup the source data as 'text', then format i
after it was spat back out of the userform.

Cheers

Ro

--
system
-----------------------------------------------------------------------
systemx's Profile: http://www.excelforum.com/member.php...fo&userid=2925
View this thread: http://www.excelforum.com/showthread.php?threadid=56652