# HEX2DEC Function – Google Sheets

The HEX2DEC function in Google Sheets converts a signed hexadecimal number to its decimal equivalent.

## Syntax

The syntax for the HEX2DEC function is:

`=HEX2DEC(hexadecimal_number)`

• `hexadecimal_number` – The hexadecimal number for the function to convert.
• You can enter the hexadecimal number as a text string or number. For example, the following formulas are equivalent. `=HEX2DEC("199")` is the same as `=HEX2DEC(199)`.

## HEX2DEC Examples

Spreadsheet users can employ the HEX2DEC function to convert hexadecimal numbers to decimal numbers for various purposes. For example, you can use the HEX2DEC function to convert hexadecimal color codes to decimal values.

## Example 1 – Converting Color Codes

First, see how the following formula converts the hexadecimal color code #`FF0000` to the decimal value 16711680.

`=HEX2DEC("FF0000")`

## Example 2 – Converting Memory Addresses

Next, we’ll look at how to use the HEX2DEC function to convert hexadecimal memory addresses to decimal values. The following formula converts the hexadecimal memory address 0x12345678 to the decimal value 305419896:

`=HEX2DEC("0x12345678")`

## Example 3 – Converting Unicode

Now let’s convert the Unicode for an emoji from signed hexadecimal to decimal. The signed hexadecimal code for a grinning face emoji ðŸ˜€ is 1F600. You need to convert the number to decimal to use it with the CHAR function.

`=CHAR(HEX2DEC("1F600"))`

## Live Example in Google Sheets

You can make a copy of this spreadsheet to see these examples and use them in your work.