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
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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.

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


Open in new window


for cell A9, use:


Open in new window


Experts Exchange Solution brought to you by

Your issues matter to us.

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

Start your 7-day free trial
Ryan Chong

;) Thnks! !!
Great Job Expert !
Rob HensonFinance 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.
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.