I want to generate 3 digit numbers out of 0 to 9 number

[Biyani]

I have numbers from 0 to 9 and I want to generate 3 digits from them, please
let me know how?

 

[Gary''s Student]

=RANDBETWEEN(0,9) & RANDBETWEEN(0,9) & RANDBETWEEN(0,9)

 

[JoeU2004]

I have numbers from 0 to 9 and I want to generate 3 digits from them,
please let me know how?

Does the following meet your needs?

=RANDBETWEEN(0,999)

formatted with the custom format 000.

 

[Gary''s Student]

If you do not want any repeated digits, then in A1 thru A10 enter:
=RAND()
and use:

=(MATCH(LARGE(A1:A10,1),A1:A10,0)-1)&(MATCH(LARGE(A1:A10,2),A1:A10,0)-1)&(MATCH(LARGE(A1:A10,3),A1:A10,0)-1)