Tips for Spreadsheets

*Summary: Converting numbers in a Microsoft Excel 2003 spreadsheet between decimal, binary, octal, and hexadecimal numbering systems.*

Software developers and electrical engineers: Need to convert numbers in your Microsoft Excel 2003 spreadsheet between the standard (decimal - base 10) and these numbering systems?

* Binary (base 2) 0-1

* Octal (base 8) 0-7

* Hexadecimal (base 16) 0-F

The following formulas will do the trick. Note you must install the Analysis ToolPak Add-In for these functions to work.

=DEC2BIN: Convert decimal number to binary

=DEC2OCT: Convert decimal numbers to octal

=DEC2HEX: Convert decimal numbers to hexadecimal

=BIN2DEC: Convert binary number to decimal

=BIN2OCT: Convert binary numbers to octal

=BIN2HEX: Convert binary numbers to hexadecimal

=OCT2BIN: Convert octal numbers to binary

=OCT2DEC: Convert octal number to decimal

=OCT2HEX: Convert octal numbers to hexadecimal

=HEX2DEC: Convert hexadecimal number to decimal

=HEX2BIN: Convert hexadecimal numbers to binary

=HEX2OCT: Convert hexadecimal numbers to octal

Note that invalid numbers may result in the cell displaying **#NUM!**.

Here are some examples:

**=DEC2BIN(64)**

1000000

**=BIN2OCT(0111)**

7

**=OCT2HEX(17)**

F

**=HEX2DEC("CAB")**

3243

Note: As shown by the last example, when converting hexadecimal numbers that include A-F, you should surround the number with quotes, otherwise Microsoft Excel 2003 may display **#NAME?** in the cell.

Add: Del.icio.us | Digg | Furl | My Yahoo!

*Last Modified on: July 13, 2008, at 12:04 A.M. EDT*

Return to the Microsoft Excel 2003 Functions and Formulas page.

Search the Site: