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.
 
Search JabSto ::




Custom Search