Related Article: Redirected to https://support.apple.com/guide/numbers/whats-new-in-numbers-132-tan700f60676/mac [was: What’s new in Numbers for Mac]

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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?

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

Posted on Jan 17, 2022 7:26 PM

Reply
Question marked as Best answer

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

Posted on Jan 17, 2022 8:28 PM

2 replies
Question marked as Best answer

Jan 17, 2022 8:28 PM in response to kevlarpeters

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

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?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.