dec2hex excel
Vauxdvihl,
Multiply 0,1 By 2^32 in decimal. The result is 429496729.6
.
Round the result to an integer. The result is 429496730.
.
Convert the integer result to Hex. The result is 1999999A.
.
The result is the base 32 representation of the fraction with the MSB having a weighting of 0,5.
.
Excel has a function "DEC2HEX" That converts decimal to hex. So you would do the multiplication and rounding in Excel, and then use "=DEC2HEX(429496730,8) to get the final result.
.
You must install the Excel Analysis Tool Pack in order to get the function "DEC2HEX" in Excel:
.
On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.
If necessary, follow the instructions in the setup program.
Regards,
Kral
Added after 2 minutes:
I'm not sure how the smiley face got into the reply. It should read =DEC2HEX(429496730,8)
Added after 2 minutes:
It got in there again! the characters after the comma should be 8). Can anybody help me on this?
Added after 2 minutes:
One more try! The characters after the comma should be the numeral 8 followed by a right parentesis. Help!!