| Home |
| Search |
| Today's Posts |
|
#5
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. . . . ... In cell B1 I wrote the following : =LEN(A1-INT(A1)) Use =LEN(ABS(A1))-LEN(INT(ABS(A1)))-(A1<INT(A1)) instead. Here is a shorter formula which also appears to work... =MAX(0,LEN(A1)-FIND(".",A1&".")) Rick |
| 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
