Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting

Converting Between Numeric Systems (BASE)

Syntax: BASE(Number; Base; Min_Length)

This function converts numbers into text strings that represent the numbers in a different numeric system. It is useful for turning decimal numbers into binary, octal, and hexadecimal numbers. For example:

=BASE(12; 2; 16)

turns number 12 into the string 0000000000001100 (binary number), while

=BASE(12; 8; 16)

turns number 12 into the string 0000000000000014 (octal number), and

=BASE(12; 16; 16)

turns 12 into the string 000000000000000C (hexadecimal number).

Figure 10-1. Sample result of the BASE function

As you can see, it is possible to specify the minimum ...