Excel function to convert hexadecimal to floating point number - ieee 754

The following piece of VBA is an Microsoft Excel worksheet function that converts a 32 bit hex string into its decimal equivalent as an ieee 754 floating point (real) number - it returns a double. This only works if the hexadecimal number is all in lower

davestow.com