Is there any way to change the base of numbers within a numbers spreadsheet? For example, express numbers in binary or base 4 instead of the traditional base 10?
I want to make a spreadsheet using different bases within the spreadsheet.
MacBook, OS X 10.11
Yes. Check out the NUMTOBASE and BASETONUM functions.
The NUMTOBASE function converts a number from base 10 into a number in the specified base. NUMTOBASE(decimal-string, base, convert-length)
The BASETONUM function converts a number of the specified base into a number in base 10. BASETONUM(convert-string, base)
Also note the Numeral System Data Format for formatting the display of values in cells:
SG
Yes. Check out the NUMTOBASE and BASETONUM functions.
The NUMTOBASE function converts a number from base 10 into a number in the specified base. NUMTOBASE(decimal-string, base, convert-length)
The BASETONUM function converts a number of the specified base into a number in base 10. BASETONUM(convert-string, base)
Also note the Numeral System Data Format for formatting the display of values in cells:
SG
Brilliant, Thank you!
Is there anyway to change the base of numbers within a numbers spreadsheet? For example, express numbers in binary or base 4 instead of the traditional base 10?
