NumDigits Function

  • Updated

Returns the number of digits in a given number, not counting trailing zeros to the right of the decimal point nor any leading zeros.

Syntax

 

Returns the number of digits in a given number, not counting trailing zeros to the right of the decimal point nor any leading zeros.

 

NumDigits(value)

 

 

Arguments:

 

 

 

value

Numeric - The number whose digits should be counted. Some input numbers will be rounded because the computer cannot store all the places.

Remarks

  • Example: NumDigits(0123.4567) returns 7.
  • Example: NumDigits(1234567890.1234567890123456789012345) returns 29 because the input is rounded to 1234567890.1234567890123456789.
  • Example: NumDigits(0.12345678901234567890123456789012345) returns 28 because the input is rounded to 0.1234567890123456789012345679.
  • Example: NumDigits(0.00123000) returns 3 because neither the leading nor trailing zeros are counted.

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.