=RANDBETWEEN(1e+9,1e+10-1)
I want to generate random number between 0 to 9 but must be fixed 10 digit length.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
Perhapsif that fails then you would need to provide a more logical explanation.Excel Formula:=RANDBETWEEN(1e+9,1e+10-1)
I am refering length of number as 10 not dighit 10 . Len(a1) =10 ...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.
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 .like this?=BASE(RANDBETWEEN(0,9),10,10)
or repeat ten times=RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&.... and so on
So that you can spam people with unsolicited marketing calls? ?Like mobile numbers .