Apple iWork '09 - Manual (Page 84)

Examples
=DEC2BIN(100) returns 01100100.
=DEC2BIN(”1001”, 12) returns 001111101001.
Related Topics
For related functions and additional information, see:
“BIN2DEC” on page 76
“DEC2HEX” on page 84
“DEC2OCT” on page 85
“HEX2BIN” on page 89
“OCT2BIN” on page 93
“Listing of Engineering Functions” on page 72
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
DEC2HEX
The DEC2HEX function converts a decimal number to the corresponding hexadecimal
number.
DEC2HEX(decimal-string, convert-length)
 decimal-string: The string representing the number to be converted. decimal-string
is a string value. It must contain only the numbers 0 through 9.
 convert-length: An optional value specifying minimum length of the number
returned. convert-length is a number value and must be in the range 1 to 32. If
omitted, it is assumed to be 1. If included, convert-string is padded with leading
zeros, if necessary, so that it is at least the length specified by convert-length.
Examples
=DEC2HEX(100) returns 64.
=DEC2HEX(”1001”, 4) returns 03E9.
84 Chapter 5 Engineering Functions