Manuals/calci/PADZEROES
Jump to navigation
Jump to search
PADZEROES(Number,Digits)
- where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Number} is the number to be displayed,
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Digits} is the total number of digits.
Description
- This function pads the given number with zeroes till the mentioned total number of digits are satisfied.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Digits} should be greater than number of digits of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Number} . Else this function returns the same number as in argument without any padding.
- For the fractional value of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Digits} , it is rounded off to nearest integer.
e.g PADZEROES(20,3.6) displays '0020'. (Rounded off to 4 digits)
Examples
- =PADZEROES(4,6) = 000004
- =PADZEROES(678,5) = 00678
- =PADZEROES(-7,3) = 0-7
- =PADZEROES(45.5,5) = 00045.5
- =PADZEROES(59,5.7) = 000059
Related Video
See Also
References