Thread: I want to generate 3 digit numbers out of 0 to 9 number
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
  
Posts: 2,059
Default I want to generate 3 digit numbers out of 0 to 9 number
"Biyani" wrote:
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.
Reply With QuoteReply With Quote