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.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« The new Mac vs. PC web ad by Apple is really cool||5 visualizations to inspire you [Nov 21] »|