ExcelBanter - Count decimals

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Count decimals (https://www.excelbanter.com/excel-discussion-misc-queries/256468-count-decimals.html)

backmara

Count decimals

How to count decimals in excel cell?
1.235 -- 3

מיכאל (מיקי) אבידן

Count decimals

One way will be: =LEN(A1)-FIND(".",A1)
Micky

"backmara" wrote:

How to count decimals in excel cell?
1.235 -- 3

backmara

Count decimals

Hi,

This works: =LEN(A1)-FIND(".";A1)

"מיכאל (מיקי) אבידן" kirjoitti:

One way will be: =LEN(A1)-FIND(".",A1)
Micky

"backmara" wrote:

How to count decimals in excel cell?
1.235 -- 3

All times are GMT +1. The time now is 02:25 PM.