HEX2FLOAT

Converts a hexadecimal number to a floating point number. Floating point numbers are represented as a 32bit-IEEE-754 number.

Syntax

=HEX2FLOAT(Number)

Arguments

Name	Description
Number	The hexadecimal number to convert.

Return

The floating point number or a #NUM! error if given number is not a valid hexadecimal number.

Examples

Formula	Result	Comment
=HEX2FLOAT("40490FDB")	3.1415927410125732421875	converts hexadecimal number 40490FDB to floating point number