Count the digit T

count the digits in column B the show how many digits are in column   A

as show here

here the file
8976453_CTO_b_convert_W.xlsm
Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Business Systems Analyst , ex-Senior Application EngineerCommented:
in cell A7, try use formula:

``````=LEN(D7)
``````

?

for cell A9, use:

``````=LEN(D9)
``````
8976453_CTO_b_convert_W_b.xlsm

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

ACCOUNTING ASSISTANTAuthor Commented:
Ryan Chong

;) Thnks! !!
ACCOUNTING ASSISTANTAuthor Commented:
Great Job Expert !
Finance AnalystCommented:
The LEN function will only work where the cell content is text and there is not custom formatting in place to adjust the appearance of the cell.

With your example in B7, the leading zeros will be counted if it is a text string but if it is a true number and it is custom formatted to "0000000000" (ten digits) the length will still show as 8.

Likewise, the LEN function doesn't work well on dates unless they are a text string. For example, today's date (27 Feb 2018), the LEN function would return 5 because the date is represented by the serial number 43158 which is 5 digits long, even if it is formatted to show as a date in any format.

Another example of incorrect use; If you have a number like 56854.2 in a cell and have it custom formatted to "0000000" (7 digits with no decimals) there would be an incorrect positive result. The LEN function would return 7 and it would appear to be correct because of the formatting but the reason it is correct is because the number is made up of 7 characters; 5 before the decimal, the decimal and then one after the decimal.

Hope that helps.
ACCOUNTING ASSISTANTAuthor Commented:
Rob Henson

Thanks for the help
you are always welcome!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.