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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lenght of a decimal part of a number.
Try
=A5-INT(A5) copy the result and paste special as values in a cell, now check what you got http://www.cpearson.com/excel/rounding.htm -- Regards, Peo Sjoblom "Yara" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lenght of a decimal part of a number.
Yara wrote...
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lenght of a decimal part of a number.
or you could try this
=LEN(TEXT(A5-INT(A5),"#.#####"))-1 |
#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 |
Reply |
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 |