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 .

 

[jasonb75]

Not sure what you're referring to there, random numbers between 0 and 9 will be 1 digit, not 10. 0^10 is still 0, 9^10 is 3486784401

Perhaps

=RANDBETWEEN(1e+9,1e+10-1)

if that fails then you would need to provide a more logical explanation.

 

[navinrb]

Not sure what you're referring to there, random numbers between 0 and 9 will be 1 digit, not 10. 0^10 is still 0, 9^10 is 3486784401

Perhaps

=RANDBETWEEN(1e+9,1e+10-1)

if that fails then you would need to provide a more logical explanation.

I want to generate random number between 0 to 9 but must be fixed 10 digit length.

 

[jasonb75]

As I already said, numbers between 1 and 9 are 1 digit, not 10.

If my suggested formula is not what you need then you will need provide more (clearer) information. Simply repeating what you already said does not make it any clearer.

 

[navinrb]

As I already said, numbers between 1 and 9 are 1 digit, not 10.

If my suggested formula is not what you need then you will need provide more (clearer) information. Simply repeating what you already said does not make it any clearer.

I am refering length of number as 10 not dighit 10 . Len(a1) =10 ...

 

[sandy666]

like this? =BASE(RANDBETWEEN(0,9),10,10)
or repeat ten times =RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&.... and so on

 

[jasonb75]

Please refer to the second line of post 4. I assume that you have tried the formula that I suggested?

 

[navinrb]

Please refer to the second line of post 4. I assume that you have tried the formula that I suggested?

Yeah thanks its working but what if i want zero before some numbers.

 

[navinrb]

like this? =BASE(RANDBETWEEN(0,9),10,10)
or repeat ten times =RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&.... and so on

Tried yours but its repeating only 1 digit ten times ..i m trying to generate random numbers with fixed length of 10. Like mobile numbers .

 

[jasonb75]

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.

Like mobile numbers .

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