HOW DO I CONVERT A NUMBER'S MOST SIGNIFICANT DIGIT TO A SINGLE DI.
 

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?

HOW DO I CONVERT A NUMBER'S MOST SIGNIFICANT DIGIT TO A SINGLE DI.
 

First stop using capitals, as it is considered yelling.

Tyro

"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?

HOW DO I CONVERT A NUMBER'S MOST SIGNIFICANT DIGIT TO A SINGLE DI.
 

On Sat, 22 Mar 2008 18:53:01 -0700, maxq777
wrote:

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?


I believe:

=--MID(A1,MIN(SEARCH({1,2,3,4,5,6,7,8,9},A1&"12345678 9")),1)

will return the most significant digit as an integer.
--ron

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?

HOW DO I CONVERT A NUMBER'S MOST SIGNIFICANT DIGIT TO A SINGLEDI.
 

Hello,

Another solution might be
=--LEFT(TEXT(ABS(A1),"0.000000000000000E+0"),1)

Regards,
Bernd