HEX.TO.FLOAT
Converts a hexadecimal number to a floating point number. Floating point numbers are represented as a 32bit-IEEE-754 number.
Syntax
=HEX.TO.FLOAT(Number)
Arguments
| Name | Type | Description |
|---|---|---|
| Number | Number | The hexadecimal number to convert. |
Return
| Type | Description |
|---|---|
| Number or Error | The floating point number or a #NUM! error if given number is not a valid hexadecimal number. |
Examples
| Formula | Result | Comment |
|---|---|---|
| 3.1415927410125732421875 | converts hexadecimal number 40490FDB to floating point number |