How to perform Binary to Hexadecimal conversion in Excel? example

How to perform Binary to Hexadecimal conversion in Excel? example

BIN2HEX

Since binary represents 0 and 1 sometimes user may require to perform Binary to Hexadecimal conversion in excel. BIN2HEX formula offers Binary to Hexadecimal conversion in Excel.

Syntax

=BIN2HEX(number, [places])

Parameters

  1. number: a mandatory parameter, refers to binary number, it should not be more that 10 bits (characters)
  2. places: its an optional parameter, it pads the value with leading zeros

Formula example

Output

Next >> Convert Binary to Decimal in Excel with example

Leave a Reply

Your email address will not be published. Required fields are marked *