Random number generator for a given length

[moonbeam]

I need to generate random numbers on certain length that is input by the user.

For eg.
If the user inputs the value 5, a random number of 5 digits should be generated

and user can input any value between 1 and 30 and a number with that many digits should be generated.

I searched quite a bit before posting this, but could not find any posts that could help me

 

[Dryver14]

there may be a better way but you get the idea here

Sheet1

	A	B	C	D
3	2			93

<tbody>
</tbody>

Spreadsheet Formulas

Cell Formula D3 =IF(A3=1,RANDBETWEEN(0,9),IF(A3=2,RANDBETWEEN(10,99),IF(A3=3,RANDBETWEEN(100,999),IF(A3=4,RANDBETWEEN(1000,9999),IF(A3=5,RANDBETWEEN(10000,99999)))))) Randbetween not available in 2003 <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[Dryver14]

Sorry, I never saw that you wanted to out to 30 digits, this will not go that far out.

 

[shg]

= LEFT(RANDBETWEEN(1,9)
& RANDBETWEEN(0,999999999999999)
& RANDBETWEEN(0,999999999999999), A1)

The results is a text string (numbers in Excel can only have 15 significant digits)