Generate Large Random number (125 digits) without scientific E+ at end

[robbertly]

Hi All,

Quick question.

I want to generate a list of random numbers each 125 digits long, including zeros, with a full output - not reduced to an E+ number.

Excel seems to have limit on the RAND and RANDBETWEEN after about 17 digits.

Any suggestions appreciated.

Thanks,

 

[Special-K99]

Build a string using VBA, insert some character at the beginning so Excels knows it's a string, then loop 125 times.

Why on earth would you need a random number 125 digits long?

 

[Peter_SSs]

You could use the long-winded formula shown in F1 below, or a user-defined function with code along the lines suggested by Special-K99.
To implement the UDF..
1. Right click the sheet name tab and choose "View Code".
2. In the Visual Basic window use the menu to Insert|Module
3. Copy and Paste the code below into the main right hand pane that opens at step 2.
4. Close the Visual Basic window.
5. Enter the formula as shown in G1 below and copy down if required.
6. Your workbook will need to be saved as a macro-enabled workbook (*.xlsm)

Function Lrand(n As Long) As String
  Dim i As Long
  Randomize
  
  For i = 1 To n
    Lrand = Lrand & Int(Rnd() * 9)
  Next i
End Function

<div class="cms_table">

Excel Workbook
	F	G
1	89134224733765303999552336861567920245085820631942462553245044811404020963843881349230429525626142463964655306164742350904316	40233817685720264032351840636244646886728201601341014575512283605154814112720608855814806315360257573610558213100746146722820
Long Rand

</div>