Generating Random Phone Numbers
Often when you are writing code or testing an application, it might be helpful to have random phone numbers generated for you.
Here is an excel formula that I use:
try these 2 instead (thanks to John)
=RANDBETWEEN(1000000000,9999999999) [needs analysis toolpack add-in or excel 2007]
Even though it works most of the time as excel rand() formula generates long decimal values between 0 and 1, it often returns fewer than 10 digits. You can add zeros at the left side to compensate that though.
Here is a shared Google docs spreadsheet with 200 random phone numbers generated for you. I am not sure how often Google refreshes the formulas on shared workbooks, so please be patient if you see same numbers generated twice.
Do you want to be awesome in Excel?
Here is a smart way to become awesome in Excel. Just signup for my Excel newsletter. Every week you will receive an Excel tip, tutorial, template or example delivered to your inbox. What more, as a joining bonus, I am giving away a 25 page eBook containing 95 Excel tips & tricks. Please sign-up below:
Your email address is safe with us. Our policies
Leave a Reply
|vlookup(), match() and offset() – explained in plain english [spreadcheats]||5 visualizations to inspire you [Nov 21]|