|
|
|
|
New Member
|
|
Mar 22, 2012, 03:11 AM
|
|
How to convert dec 1983283028577193161 to hex in excel? Please help me
|
|
|
New Member
|
|
Apr 30, 2012, 05:15 AM
|
|
Can someone please tell me how to convert a 17 digit decimal number 10 hexadecimal in excel?
|
|
|
New Member
|
|
Jul 10, 2013, 05:42 PM
|
|
Instead of hex2sgn() name should be HEX2FLOAT() and in capital characters
|
|
|
New Member
|
|
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.
|
|
Question Tools |
Search this Question |
|
|
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
|