Format cells in custom format to

###-##-####

then enter this in your cells

=RAND()*(999999999-100000000)+100000000

It appears to work

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566371