FLOAT2BIN
Converts a floating point number to binary. Floating point numbers are represented as a 32bit-IEEE-754 number.
Syntax
=FLOAT2BIN(Number)
Arguments
| Name | Description | 
|---|---|
| Number | The floating point number to convert. | 
Return
The binary number or a #NUM! error if given number is not a valid floating point number.
Examples
| Formula | Result | Comment | 
|---|---|---|
 | 01000000001001000100100110111010 | converts floating point 2.567 to binary |