The quickest and easiest way to enter a static random number is to use the Immediate window. From your keyboard, press Alt+F11 then press Ctrl+G I typed this line of code into the Immediate window… Range ("A1").Value = Format (Rnd () * 99 + 1, "000")
Whatever text you enter into the options text field will be used to generate telephone numbers. Capital X's will be converted to a random number between 1 and 9; lower-case x's will be converted to a random number between 0 and 9. Select one of the values in the example dropdown for some ideas.