Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
Counting decimals: 1.234 -- 3 11.2 -- 1 1.34 -- 2 How I do that? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
=LEN(A1)-FIND(".",A1) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "backmara" wrote: Hi, Counting decimals: 1.234 -- 3 11.2 -- 1 1.34 -- 2 How I do that? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try
=IF(MOD(A1,1),LEN(MOD(A1,1))-2,0) -- Jacob "backmara" wrote: Hi, Counting decimals: 1.234 -- 3 11.2 -- 1 1.34 -- 2 How I do that? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
One should check his previous posts/Questions - could be somebody found a few
moments, of his precious time, to present the answer. Micky "backmara" wrote: Hi, Counting decimals: 1.234 -- 3 11.2 -- 1 1.34 -- 2 How I do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Decimals, how? | Excel Discussion (Misc queries) | |||
Decimals? | Excel Discussion (Misc queries) | |||
no decimals | Excel Discussion (Misc queries) | |||
decimals only. | Excel Discussion (Misc queries) | |||
using decimals points | Setting up and Configuration of Excel |