Engineering

OCT2DEC Function in Excel

Converts an octal number to decimal.

Syntax

  • =OCT2DEC(number)

Arguments

  • number (required): Octal number

Examples

  • =OCT2DEC(54) - Octal to decimal - Result: 44

OCT2DEC in technical sheets

  • Document units in adjacent cells — many engineering functions require exact unit strings.
  • Use [CONVERT](/functions/convert/) for unit changes before specialized formulas.
  • Validate inputs with [ISNUMBER](/functions/isnumber/) and range checks.

Common errors

  • #NUM! if not valid octal

Use cases

  • Unix permissions
  • Number conversion
  • Programming

Frequently asked questions

  • What is the OCT2DEC function in Excel? OCT2DEC converts an octal number to decimal. The syntax is =OCT2DEC(number). Typical use cases include unix permissions, number conversion, programming.
  • How do I use the OCT2DEC function? To use OCT2DEC, type =OCT2DEC( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
  • Why is OCT2DEC not working in my Excel? Common issues with OCT2DEC include #NUM! if not valid octal. Start by checking the syntax =OCT2DEC(number), then verify each referenced cell or range.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.

When to use OCT2DEC

  • Unix permissions — common Engineering scenario for OCT2DEC.
  • Number conversion — common Engineering scenario for OCT2DEC.
  • Programming — common Engineering scenario for OCT2DEC.

OCT2DEC in the Engineering category

  • Browse all Engineering functions at /categories/engineering/ for related formulas.
  • OCT2DEC syntax: =OCT2DEC(number)
  • number (required): Octal number
  • Confirm OCT2DEC arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.

Formula checklist before you copy down

  • Confirm OCT2DEC arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.
  • If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
  • Spot-check three known input rows manually against expected output.

Related Excel functions

  • DEC2OCT (/functions/dec2oct/): Converts a decimal number to octal.
  • OCT2BIN (/functions/oct2bin/): Converts an octal number to binary.
  • OCT2HEX (/functions/oct2hex/): Converts an octal number to hexadecimal.

Errors to watch for

  • #NUM! if not valid octal — review causes on linked error pages in the directory.

Copy-paste audit workflow

  • Enter OCT2DEC on three test rows with known expected output documented on a QA tab.
  • Fill down only after absolute references are locked on lookup tables and rate tables.
  • Compare against manual calculation or a calculator for financial and statistical functions.
  • Search this directory for comparison guides when choosing between similar functions in the same category.

OCT2DEC worked examples to copy

  • =OCT2DEC(54) — Octal to decimal. Expected result: 44.

OCT2DEC reference summary for crawlers and offline review

  • OCT2DEC belongs to the Engineering category in Excel. Converts an octal number to decimal.
  • Full syntax: =OCT2DEC(number). Open /functions/oct2dec/ for parameters, FAQs, and related pages.
  • Common mistakes: #NUM! if not valid octal
  • Pair this function with comparison guides when another Excel formula might fit the same task better.
  • Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.