How to generate fixed length of random numbers ?

[navinrb]

Please help to generate random numbers between 0 -9 with fixed length of 10 digits .
I applied randbetween (0^10,9^10) but its generating some nine or eight digits also....
Thanks in advance .

 

[sandy666]

show representative example

 

[navinrb]

Then you need to use 0 as the lower limit for the formula and apply a custom format to the cell so show 10 digits.

So that you can spam people with unsolicited marketing calls? ?

Lol nooooo.???... i m refering just length as mobile numbers as its always 10.?

 

[navinrb]

show representative example

Like.
0123456789
1265890056
5678967803
9876543217

 

[sandy666]

try

0825088883
3396680293
6403055112
1309056566
3582188093
7589873653
6593737129
1538303915
4221790517
=BASE(RANDBETWEEN(0+1,10000000000-1),10,10)

I know, I know 0+1 = 1 but looks fine

 

[navinrb]

try

0825088883
3396680293
6403055112
1309056566
3582188093
7589873653
6593737129
1538303915
4221790517
=BASE(RANDBETWEEN(0+1,10000000000-1),10,10)

I know, I know 0+1 = 1 but looks fine

Yeah its what i am looking for as i got some numbers with starting zero also but.also numbers are on text format...if i convert to numbers its lenght are changing..so i think i need to custom format that to . Thank you. !

 

[sandy666]

sure, you are welcome
but this is not my formula but idea was from @jasonb75 I added BASE() only

 

[Rick Rothstein]

What about this formula...

=TEXT(RANDBETWEEN(1,9999999999),"0000000000")

 

[navinrb]

What about this formula...

=TEXT(RANDBETWEEN(1,9999999999),"0000000000")

Thank you . Its working perfectly.

 

[sandy666]

=--BASE(RANDBETWEEN(0+1,10000000000-1),10,10)

=--TEXT(RANDBETWEEN(1,9999999999),"0000000000")

in both cases you'll need custom format: 0000000000

sndt92571
	N	O	P	Q
2	2194825659	FALSE	4848353253	FALSE
3	0064304559	FALSE	1458794558	FALSE
4	2280579066	FALSE	2342533274	FALSE
5	5809461393	FALSE	2265793016	FALSE
6	6913740385	FALSE	3491902189	FALSE
7	9479543107	FALSE	0327652159	FALSE
8	9835743754	FALSE	0139016119	FALSE
9	7823466006	FALSE	8090131182	FALSE
10	6091269488	FALSE	8652885990	FALSE
11	5493198772	FALSE	9978394240	FALSE
12	4646844027	FALSE	8230367620	FALSE
Sheet1

Cell Formulas
Range	Formula
N2:N12	N2	=--TEXT(RANDBETWEEN(1,9999999999),"0000000000")
O2:O12,Q2:Q12	O2	=ISTEXT(N2)
P2:P12	P2	=--BASE(RANDBETWEEN(0+1,10000000000-1),10,10)

 

[Rick Rothstein]

My original formula returned Text values. Sandy's post has formulas returning real numbers which you must then custom format in order to retain leading zeros. We do not know whether you need to use these numbers in some kind of mathematical formula or if they are ID's or have some other purpose that do not require them to be used in further numerical calculations. If the latter, my original formula will work fine for you, but if you need real numbers that have to be custom formatted, then instead of converting my original formula the way Sandy did, I would simply use this formula instead and then custom format it...

=RANDBETWEEN(1,9999999999)