How to use the OCT2BIN Function in Excel Office 365?
Tags: tousetheoct2binfunct, excel, excelfunctions
Published: 2021-08-27 02:09:17

---
title: How to use the OCT2BIN Function in Excel Office 365?
published: true
date: 2021-08-24 16:03:42 UTC
tags: ToUseTheOCT2BINFunct,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-oct2bin-function-in-excel-office-365/
---

In this article, you will learn how to use **OCT2BIN**  **Function in Excel 365** using its basic syntax, explanation, and examples. Let’s see them below!! Get the official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## OCT2BIN – Function Explanation

- **OCT2BIN**  **function** is mainly used to convert **octal representation of numbers of radix 8 to binary numbers**.
- This function is just opposite to **[BIN2OCT Function](https://geekexcel.com/how-to-use-bin2oct-function-in-microsoft-excel-365-with-examples/)**.

## OCT2BINFunction Syntax

```
=OCT2BIN ( number, [places] )
```

**Syntax Explanation:**

- **Number** : Octal number, which returns the 10 character binary number.
- **[Places]** : [optional] number, where result expressed up to the number.

## Example

- Firstly, you need to **create a sample data** with **octal values**  **in Octal Column**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Sample-data-31.png)<figcaption>Sample data</figcaption>

- Then, you have to convert these **octal numbers to binary value**.
- Now, you need to use the following **formula** given below.

```
=OCT2BIN (A2)
```

**A2:** number provided to the function as a cell reference.

![](https://geekexcel.com/wp-content/uploads/2021/08/Use-the-formula-4.png)<figcaption>Use the formula</figcaption>

- After that, the **OCT2BIN** representation of **2 of base 8** (binary) is **10 of base 2** (decimal).
- Now, you have to copy the **formula to other cells** using the **Ctrl + D** shortcut key.

![](https://geekexcel.com/wp-content/uploads/2021/08/Copy-the-formula-to-other-cells-2.png)<figcaption>Copy the formula to other cells</figcaption>

**Check this too:** [How to Use Excel BIN2HEX Function in Office 365? {With example}](https://geekexcel.com/how-to-use-bin2hex-function-in-excel-365-with-example/)

## Summary

We hope that this short tutorial gives you guidelines to **use the OCT2BIN**  **Function In Excel Office 365. ** Please leave a comment in case of any **queries,** and don’t forget to mention your valuable **suggestions** as well. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Also:**

- **[How to Use Excel BIN2OCT Function in Microsoft Office 365?](https://geekexcel.com/how-to-use-bin2oct-function-in-microsoft-excel-365-with-examples/)**
- **[How to Select Cells Based on Color/Formatting in Excel Office 365?](https://geekexcel.com/how-to-select-cells-based-on-color-formatting-in-excel-office-365/)**
- **[Excel Formulas to Calculate the Tax Rate with Fixed Base with IF Function!](https://geekexcel.com/excel-formulas-to-calculate-the-tax-rate-with-fixed-base-with-if-function/)**
- **[How to Use Excel BIN2DEC Function in Office 365? (With Examples)](https://geekexcel.com/how-to-use-bin2dec-function-in-excel-365-with-examples/)**