Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Formula for converting 32 bit Hexadecimal into decimal in EXCEL (https://www.askmehelpdesk.com/showthread.php?t=396581)

  • Mar 22, 2012, 03:11 AM
    munakk
    How to convert dec 1983283028577193161 to hex in excel? Please help me
  • Apr 30, 2012, 05:15 AM
    KARA1234
    Can someone please tell me how to convert a 17 digit decimal number 10 hexadecimal in excel?
  • Jul 10, 2013, 05:42 PM
    marceli
    Instead of hex2sgn() name should be HEX2FLOAT() and in capital characters
  • Nov 24, 2013, 12:08 PM
    thisismikekane
    Its not pretty, but you can use the following function to convert a 32-bit hexdecimal string into the equivalent IEEE-754 32-bit floating point value

    Code:

    =(IF(LEFT(CONCATENATE(RIGHT("00000000"&HEX2BIN(MID(A1,(1-1)*2+1,2)),8),RIGHT("00000000"&HEX2BIN(MID(A1,(2-1)*2+1,2)),8),RIGHT("00000000"&HEX2BIN(MID(A1,(3-1)*2+1,2)),8),RIGHT("00000000"&HEX2BIN(MID(A1,(4-1)*2+1,2)),8)),1)="0",1,-1))*((BIN2DEC(MID(CONCATENATE(RIGHT("00000000"&HEX2BIN(MID(A1,(1-1)*2+1,2)),8),RIGHT("00000000"&HEX2BIN(MID(A1,(2-1)*2+1,2)),8),RIGHT("00000000"&HEX2BIN(MID(A1,(3-1)*2+1,2)),8),RIGHT("00000000"&HEX2BIN(MID(A1,(4-1)*2+1,2)),8)),10,7))*256*256+BIN2DEC(MID(CONCATENATE(RIGHT("00000000"&HEX2BIN(MID(A1,(1-1)*2+1,2)),8),RIGHT("00000000"&HEX2BIN(MID(A1,(2-1)*2+1,2)),8),RIGHT("00000000"&HEX2BIN(MID(A1,(3-1)*2+1,2)),8),RIGHT("00000000"&HEX2BIN(MID(A1,(4-1)*2+1,2)),8)),17,8))*256+BIN2DEC(MID(CONCATENATE(RIGHT("00000000"&HEX2BIN(MID(A1,(1-1)*2+1,2)),8),RIGHT("00000000"&HEX2BIN(MID(A1,(2-1)*2+1,2)),8),RIGHT("00000000"&HEX2BIN(MID(A1,(3-1)*2+1,2)),8),RIGHT("00000000"&HEX2BIN(MID(A1,(4-1)*2+1,2)),8)),25,8)))/HEX2DEC(800000)+1)*2^(BIN2DEC(MID(CONCATENATE(RIGHT("00000000"&HEX2BIN(MID(A1,(1-1)*2+1,2)),8),RIGHT("00000000"&HEX2BIN(MID(A1,(2-1)*2+1,2)),8),RIGHT("00000000"&HEX2BIN(MID(A1,(3-1)*2+1,2)),8),RIGHT("00000000"&HEX2BIN(MID(A1,(4-1)*2+1,2)),8)),2,8))-127)
    Replace all instances of A1 in the above formula with the cell reference you wish to convert.

  • All times are GMT -7. The time now is 05:13 AM.