Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find first digit of value
I have a large vector of values with a wide dynamic range (10^-6 to 10^-
16). For a particular application, I need to retrieve only the first digits of the values, yielding an output vector that contains only the values 1 through 9. I can do this manually fairly easily by first multiplying by an appropriate value to bring the result to a whole number, then truncating the fractional part. I'm sure that there must be a way to automate this in Excel, but I can't figure out how to do it. The problem seems to lie in my inability to separate the characteristic and mantissa. Any ideas? --Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find duplicate entries that have trailing digit that may change. | Excel Discussion (Misc queries) | |||
How or where do I find my 25 digit license number teacher version | New Users to Excel | |||
find the value of the last digit in a cell | Excel Worksheet Functions | |||
How to find if a string starts with a digit | Excel Worksheet Functions | |||
When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) |