Thread: urgent : count of digits in a number
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default urgent : count of digits in a number
=LEN(A1)
This includes any decimal separator. It also counts a single zero if the value is <1.

--
Kind regards,

Niek Otten


"SHIRA" wrote in message ...
|i need a function or a macro that calculates the count of digits in a number
|
|


Reply With QuoteReply With Quote