Engineering

DEC2OCT Function in Excel

Converts a decimal number to octal.

Syntax

  • =DEC2OCT(number, [places])

Arguments

  • number (required): Decimal number
  • places (optional): Number of characters to use

Examples

  • =DEC2OCT(58, 3) - Decimal to octal - Result: 072

DEC2OCT 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 out of range

Use cases

  • Unix permissions
  • Number conversion
  • Programming

Frequently asked questions

  • What is the DEC2OCT function in Excel? DEC2OCT converts a decimal number to octal. The syntax is =DEC2OCT(number, [places]). Typical use cases include unix permissions, number conversion, programming.
  • How do I use the DEC2OCT function? To use DEC2OCT, type =DEC2OCT( 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 DEC2OCT not working in my Excel? Common issues with DEC2OCT include #NUM! if out of range. Start by checking the syntax =DEC2OCT(number, [places]), then verify each referenced cell or range.

Editorial review

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