How to Use DEC2OCT Function in Excel 365? – (With Examples)
Tags: dec2octfunctioninexc, excelfunctions
Published: 2020-08-14 11:25:40

---
title: How to Use DEC2OCT Function in Excel 365? – (With Examples)
published: true
date: 2020-08-14 06:13:52 UTC
tags: DEC2OCTFunctioninExc,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-dec2oct-function-in-excel-365-with-examples/
---

## DEC2OCT Function in Excel:

In this tutorial, we will guide you to learn how to use DEC2OCT Function in Excel 365 with its syntax, definition, and examples. Let’s see them one by one. Get 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)

## Jump To:

- [**DEC2OCT – Function Definition**](#1)
- [**Syntax**](#2)
- [**Examples**](#3)
- [**Summary**](#4)

## **DEC2OCT – Function Definition:**

- This function **converts a decimal number to octal value**.
- DEC2OCT Function is just opposite to **OCT2DEC Function**.

## **Syntax:**

**=DEC2OCT(number, [places])**

**Number ** – The decimal number that you want to convert as an octal number.

**Places** – It is optional. It is used for padding the output value with leading zeros. If you don’t mention the places, it returns the exact value of the input.

### **Note:**

- If places is non-numeric, it returns **#VALUE!** Error.
- If the decimal number is less than -536,870,912  or greater than 536,870,911, it will show **#NUM!** Error value.
- If you give a negative number to the places, it returns **#NUM!** Error.

## **Examples:**

Here we come up with examples to make you understand this concept.

### Example 1:

- In the following image, you can see the input decimal value in the cell **A2** and its places is mentioned in cell **B2**.
- The converted octal number is placed in the cell **C2**.

![Decimal to Octal Conversion](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-22.png)<figcaption id="caption-attachment-11625">Decimal to Octal Conversion</figcaption>

### Example 2:

- If places is non-numeric, it returns **#VALUE!** Error.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/3-17.png)<figcaption id="caption-attachment-11626">Example 2</figcaption>

### Example 3:

- If the decimal number is less than  -536,870,912  or greater than  536,870,911, it will show **#NUM!** Error value.
- If you give a negative number to the places, it returns **#NUM!** Error.

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-19.png)<figcaption id="caption-attachment-11627">Example 3</figcaption>

## **Summary:**

To sum up, hope this tutorial guided you to learn the usage of **DEC2OCT Function in Excel 365** with its syntax, definition, and examples. Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Functions:

- [**DEC2BIN Function**](https://geekexcel.com/how-to-use-dec2bin-function-in-excel-365-with-examples/)
- [**DEC2HEX Function**](https://geekexcel.com/how-to-use-dec2hex-function-in-ms-excel-365-with-examples/)

### Keep Reading:

- [Use ISTEXT Function in Microsoft Excel 365 In Easy Ways!!](https://geekexcel.com/use-istext-function-in-microsoft-excel-365-in-easy-ways/)
- [How to Use “BITAND Function” in Excel 365? – { with Examples }](https://geekexcel.com/how-to-use-bitand-function-in-excel-365-with-examples/)
- [Use N Function in Microsoft Excel 365 -Simple methods!!](https://geekexcel.com/use-n-function-in-microsoft-excel-365-simple-methods/)