Skip to main content
Version: Streamsheets 2.5

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

NameDescription
NumberThe hexadecimal number to convert.

Return

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

Examples

FormulaResultComment
=HEX2FLOAT("40490FDB")
3.1415927410125732421875converts hexadecimal number 40490FDB to floating point number