BASETONUM
Description
Converts an integer to the specified base. Returns a string (text).
Syntax
BASETONUM(
value
,
base
, [
min_length
])
- value: The number to convert.
- base: The base for conversion. Supports values between 2 and 36.
- min_length: The minimum length of the resulting string. Leading zeros are added to the result if it is shorter than the minimum length.
Example
Formula | Result |
|---|---|
=BASETONUM(15,2) | 1111 |
=BASETONUM(15,2,8) | 00001111 |
=BASETONUM(123456,16) | 1E240 |
Notes
- This function does the same action as BASE().