Skip to main content

Convert octal value to decimal or binary or hexadecimal value

doc convert octal to decimal binary hexadecimal 1

Convert octal value to decimal value

Generic formula 1:

=OCT2DEC(text)

Arguments

  • Text: Required, the text representation of number you want to convert it from octal (base 8) to decimal (base 10) value.

Examples

Formula Description Result
=OCT2DEC(17) Convert octal value 17 to decimal value 15
=BIN2DEC(B3)
(Cell B3 contains 127)
Convert octal value 127 to decimal value 87

Generic formula 2:

=DECIMAL(text,8)

Arguments

  • Text: Required, the text representation of number you want to convert it from octal (base 8) to decimal (base 10) value.
  • 16: Required, the octal base

Examples

=DECIMAL(127,8)

Explanation:

Convert octal value 127 to decimal value.

Return

Press Enter key to return 87.

Convert octal value to binary value

Generic formula:

=OCT2BIN(text)

Arguments

  • Text: Required, the text representation of number you want to convert it from octal (base 8) to binary (base 2) value.

Examples

=OCT2BIN(127)

Explanation:

Convert octal value 127 to binary value.

Return

Press Enter key to return 1010111

Convert octal value to hexadecimal value

Generic formula:

=OCT2HEX(text)

Arguments

  • Text: Required, the text representation of number you want to convert it from octal (base 8) to hexadecimal (base 16) value.

Examples

=OCT2HEX(127)

Explanation:

Convert binary value 127 to hexadecimal value.

Return

Press Enter key to return 57.

Remarks

The Text argument in formulas must be in octal value formatting, which means the character elements must be in the scale of 0-7, or it returns #NUM! error value.


Relative Functions

  • Excel DECIMAL function
    The DECIMAL function converts a text representation of a number in a base into its equivalent decimal number. Take a instance, 11 is a text representation of 3 in base 2, using the formula =DECIMAL(11,2) convert 11 into decimal number 3.

Relative Formulas


The Best Office Productivity Tools


Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)

  • One second to switch between dozens of open documents!
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.
Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations