How to convert dec 1983283028577193161 to hex in excel? Please help me
![]() |
How to convert dec 1983283028577193161 to hex in excel? Please help me
Can someone please tell me how to convert a 17 digit decimal number 10 hexadecimal in excel?
Instead of hex2sgn() name should be HEX2FLOAT() and in capital characters
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
Replace all instances of A1 in the above formula with the cell reference you wish to convert.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)
All times are GMT -7. The time now is 03:18 AM. |