| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lenght of a decimal part of a number.
Hi, I am doing some programming where I need to know the number of digits of
the only decimal part of a number. I ended up with the following equation: In cell A1 I entered a decimal number. In cell B1 I wrote the following : =LEN(A1-INT(A1)) this should give me the numbers of the decimal part. Examples: A1 B1 100 1 10.25 4 3.2 3 6.7 3 9.2 17 WHY? this my question. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lenght of status bar | Excel Discussion (Misc queries) | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| converting number string to number with decimal | Excel Worksheet Functions | |||
| Calculating a sum of various lenght | Excel Worksheet Functions | |||
| How to convert a decimal number to a non-decimal number? | Excel Worksheet Functions | |||
Threaded Mode
