| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NEED EXCEL FORMULA TO CONVERT 13 DIGIT ISBN TO 10 DIGIT ISBN | Excel Discussion (Misc queries) | |||
| Can only put a single digit/letter in worksheet 2007 | New Users to Excel | |||
| Convert 2 digit month to 4 digit years and months | Excel Worksheet Functions | |||
| how to convert single digit to month name | Excel Worksheet Functions | |||
| Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
Threaded Mode
