View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_231_] Rick Rothstein \(MVP - VB\)[_231_] is offline
external usenet poster
 
Posts: 1
Default HOW DO I CONVERT A NUMBER'S MOST SIGNIFICANT DIGIT TO A SINGLE DI.

Just out of curiosity, in which random number function are you using this
"seed" value?

Rick


"maxq777" wrote in message
...
I am trying to work a problem for a random number generator. Essentially,
the random number is being generated by using two random number generators
(X
= 1 to 100 and Y = 1 to 100) and then dividing X by Y to get a seed for
the
random nujber.

I need to take the most significant digit of the number and convert it to
an
integer between 1 and 9.

Any idea as to how I can do this?