LinkBack URL
About LinkBacks
Hello,
I was wondering if its possible to create a RAND formula that can be used for a 11-digit Mobile Number. However I need to first 3-digits to be 077?
Thank you
Random Formula for Mobile Number
Hello,
I was wondering if its possible to create a RAND formula that can be used for a 11-digit Mobile Number. However I need to first 3-digits to be 077?
Thank you
Something like this?
=077&RANDBETWEEN(10000000,99999999)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
The formula seems to be working just fine, however the 0 at the beginning is not appearing. So it starts with 7?Originally Posted by Fotis1991
Use it in this way
="077"&RANDBETWEEN(10000000,99999999)
Oh thank you for that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks