Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Removing Borders

Converting to Octal

Filtering Columns for Unique Values

Printing Multiple Worksheets on a Single Page

Changing the Default Font

Creating a Drawing Object

Determining a Value of a Cell

 

Converting to Octal

Summary: If you need to do some work in the base-8 numbering system (octal), you'll love two worksheet functions provided by Excel for this purpose. These functions allow you to convert values to octal and convert them back again. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

There are four types of numbering systems commonly used in programming: binary, octal, decimal, and hexadecimal. Each is simply a different method of expressing the exact same values. Excel makes it easy to convert between decimal and octal numbers, and provides two worksheet functions for that very purpose.

The first function is the DEC2OCT function. Suppose you have a decimal value in cell B7, and you want to know how to express that value in octal. In a different cell you could use the following formula:

=DEC2OCT(B7)

If the value in B7 was 456, the result of the above formula would be 710. An interesting fact (and potential "gottcha") is that when the conversion is completed, Excel considers the result to be a number. Thus, if you added 8 to the resulting value above (710), Excel would return 718—a value impossible in octal. This simply means that Excel doesn't keep track of the numbering system used in a particular cell; it expects you to do that.

If you want to convert numbers back the other way, from octal to decimal, you can use the OCT2DEC worksheet function:

=OCT2DEC(B8)

If you try to use this function with a value that is clearly not octal (such as 718), then Excel returns a #NUM! error value.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2316) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Don't Go in Debt for Christmas! Tired of trying to keep up with the Joneses for Christmas? Want to enjoy the season rather than dread the aftermath? Learn how you can avoid the financial traps that spring up every Christmas.
 
Check out Top Fifteen Tips for Financing Christmas today!