Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

DEC2BIN(number,places) [Category: Engineering]*

Converts a decimal number to binary. Guru Tip: Returns up to a 10 character

result. Since each character holds a single bit, you have one sign bit and 9

magnitude bits. This means that DEC2BIN works with numbers from -512 to

+511.

DEC2HEX(number,places) [Category: Engineering]*

Converts a decimal number to hexadecimal. Guru Tip: Returns up to a 10

character result. Since each character holds 4 bits (2^4=16), the function can

represent one sign bit and 39 magnitude bits. This means that DEC2HEX works

with numbers in the range of -549,755,813,888 to +549,755,813,887. A real-life

use for DEC2HEX is converting RGB values to color codes for use in web page

design.