OCT2HEX Function | Microsoft Excel

how to use oct2hex function in excel

You can convert octal numbers into hexadecimal numbers

The hexadecimal numbers contain only 0 and F values
Octal numbers contain 0 to 7 values
OCT2HEX Function has a limit of 777 octal numbers
If you write more than 777 characters it will return #NUM error

Syntax of OCT2HEX Function


Argument of OCT2HEX Function

Number: it is the number you want to convert into hexadecimal
Places:[Optional] how many characters you want to show in your result. It will place "0" before the result.

Behavior of OCT2HEX Function

Here we have taken an example of the octal number and convert it into hexadecimal numbers.
We have written a formula  
=OCT2HEX(D4,5) which will convert the octal number into hexadecimal and show result till 5 characters. No character place is filled by 0
On the right side, if you write 777 it will return "1FF:
If you write 778 it will return #NUM error

Usage of OCT2HEX Function

To convert an Octal number into a Hexadecimal number

Returns of OCT2HEX Function

Hexadecimal number

No comments:

Post a Comment