random character gen... but how do i stop it?

[jiggaman]

Hello,

so what i need is a 6 digit alpha numeric random (1000 entries)

so from some searching i figured that it should be...

=MID(A1,1+INT(RAND()*LEN(A1)),1)&MID(A1,1+INT(RAND ()*LEN(A1)),1)&MID(A1,1+INT(RAND()*LEN(A1)),1)&MID (A1,1+INT(RAND()*LEN(A1)),1)&MID(A1,1+INT(RAND()*L EN(A1)),1)&MID(A1,1+INT(RAND()*LEN(A1)),1)


where a1 = 1234567890abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMN OPQRSTUVWXYZ


but when i fill down it auto it to a2 , then a3 etc... how do i stop that?



i might delete out the o O and 0 cause it gets confusing...

also, it re-randomizes everytime i open the file... is there a way to stop it?

any help is appreciated.

thanks

[shg]

it re-randomizes everytime i open the file... is there a way to stop it?

Copy and paste as values.

[TMS]

Change A1 to $A$1

Not sure you can stop it unless you switch calculation to manual


Regards, TMS

[FDibbins]

also, it re-randomizes everytime i open the file... is there a way to stop it?

Unless you have calcs set to manual, it will also recal with every workbook change (entering or editing something in a cell, pressing F9 etc)