Ask Experts Questions for FREE Help !
Ask
Page 2 of 2 « First < 2
    munakk's Avatar
    munakk Posts: 1, Reputation: 1
    New Member
    		  
    #21

    Mar 22, 2012, 03:11 AM
    How to convert dec 1983283028577193161 to hex in excel? Please help me
    KARA1234's Avatar
    KARA1234 Posts: 1, Reputation: 1
    New Member
    		  
    #22

    Apr 30, 2012, 05:15 AM
    Can someone please tell me how to convert a 17 digit decimal number 10 hexadecimal in excel?
    marceli's Avatar
    marceli Posts: 1, Reputation: 1
    New Member
    		  
    #23

    Jul 10, 2013, 05:42 PM
    Instead of hex2sgn() name should be HEX2FLOAT() and in capital characters
    thisismikekane's Avatar
    thisismikekane Posts: 1, Reputation: 1
    New Member
    		  
    #24

    Nov 24, 2013, 12:08 PM
    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.
Not your question? Ask your question View similar questions
 
Page 2 of 2 « First < 2

Question Tools Search this Question
Search this Question:

Advanced Search


Check out some similar questions!

Excel formula [ 15 Answers ]

Download Attachment, first. I need: -If B14=empty, then A and D colones both empty -If only B14=selected, then A14=TREZOR, D14=1, D15=1, bold underline between C14-L14 and C15-L15, others A and D empty -If B14=selected and B15=selected, then A14=TREZOR, A15=-II-, D14=1, D15=1, D16=2,...

I need a excel formula [ 2 Answers ]

Hi I need a excel formula for numbers ( Figures) are convert in words. Like Rs.20 =Twenty only( In Formula) up to 15 digit. Thanks Regards Hariom

Excel formula [ 3 Answers ]

I am using Excel 2007. I have 2 Sheets. In first sheet there are 3 coloumns, first one contains the employes number, second coloumn contains the name of employes and third one contains the department he works in. In the second sheet I have drop down list of the names of employes and the...

Excel Formula [ 1 Answers ]

Hi I have come across another problem with my spreadsheet. I have tried quite a few different ways to do it but can't get any of them to work. Within my spreadsheet I have a quote price and a forcasted date. However when a order is definitely received then a sale price and a new date is put into...

Excel formula [ 3 Answers ]

I have a column that you manually enter a number; either 0 (zero) or any number greater than zero. I have another column with the formula of: =DAYS360(AN22,AQ22) If the resulting formula figure/number is greater than the manually entered number then I want a third column to equal: $0.00 But...

View more questions Search