Wow!!!! Thanks VBA Noob!!! I have been trying to figure this out for a week
now and it only took you a couple of minutes. It absolutely works!!!!!!!!!!
Thank you so much!!!!!!!!!!!!!

VBA Noob wrote:
Format cells in custom format to

###-##-####

then enter this in your cells

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

It appears to work

VBA Noo