#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default Counting decimals

Hi,

Counting decimals:
1.234 -- 3
11.2 -- 1
1.34 -- 2

How I do that?

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default Counting decimals

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default Counting decimals

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 561
Default Counting decimals

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Decimals, how? LogiMAX Excel Discussion (Misc queries) 6 August 21st 09 11:54 AM
Decimals? Tricia LeAnn[_2_] Excel Discussion (Misc queries) 4 February 4th 08 05:00 PM
no decimals BorisS Excel Discussion (Misc queries) 1 September 18th 06 07:48 AM
decimals only. joepose Excel Discussion (Misc queries) 5 September 7th 06 01:05 PM
using decimals points Char Setting up and Configuration of Excel 2 July 27th 05 09:49 PM


All times are GMT +1. The time now is 10:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"