Signed Binary Decimal (B16) Conversion

Hello,

I'm trying to convert a range of decimal numbers from 0 to 255.9928 to hexadecimal using the Signed Binary Decimal conversion (meaning that the first bit represents the sign of the number, the next 8 bits provides the integer, then the remaining 7 bits represents the fraction).

For example, my input of 255.9928 should product the hex value of 7FE3.

Any thoughts/suggestions?

Respectfully,
Talamon

	a	b	c
1	-256.0000000	8000	b1: =right(dec2hex(a1*128, 4), 4)
2	-0.0078125	ffff
3	0.0000000	0000
4	0.0078125	0001
5	255.9921875	7fff

You're welcome.