# Formula for converting 32 bit Hexadecimal into decimal in EXCEL

Formula for converting 32 bit Hexadecimal into decimal in EXCEL.

I required a formula in the mSEXCEL for cinverting IEEE-754 32bit hexadecimal floating point representation into decimal floating point.

 nigel_cro Posts: 6, Reputation: 10 Junior Member #11 Dec 3, 2009, 07:17 AM
JB,

At the risk of being a complete PITA - I need to take a hex string (eg D0 boyfriend FF FF) and turn it to Little endian (eg FF FF boyfriend D0). I have tried to adapt some of your coding from your really helpful posting above but my VB skills are, frankly, appalling and while I can work out what your script is doing, I am not having any success in adapting it.

I'm sure this is a relatively simple couple of lines but it is beyond me.

Thanks, in advance for any help,

Nigel
 JBeaucaire Posts: 5,377, Reputation: 5036 Software Expert #12 Dec 3, 2009, 10:17 AM

If your text string in A2 is shown exactly like you demonstrated above with spaces between each quad, then use this worksheet formula to reverse the order of the quads:

=RIGHT(A2,2) & MID(A2,6,4) & MID(A2,4,3) & LEFT(A2,2)

If your data does not match this exact format, click on GO ADVANCED and use the paperclip icon to upload a sample worksheet with several examples of your data and your desired results.
 nigel_cro Posts: 6, Reputation: 10 Junior Member #13 Dec 3, 2009, 12:53 PM
JB,

Thanks for the really prompt response.

I knew I would get something wrong - I would like to input the HEX string as a continuous string, it makes the inputting process a whole lot easier, to have to include spaces would build unnecessary effort and room for error into the process.

So, the actual input will look like [D0BFFFFF] and the output would look similar [FFFFBFD0]. Just to emphasise, both input and output would be in continuous strings.

I'm sorry to have wasted your time, thanks for the help.

All the best,

Nigel
 JBeaucaire Posts: 5,377, Reputation: 5036 Software Expert #14 Dec 3, 2009, 04:19 PM

Hopefully you'll pull these two examples apart and see what's going on so you can use this technique yourself in the future.

This is for reversing your text string 2 characters at a time with no spaces:

=RIGHT(A1,2) & MID(A1,5,2) & MID(A1,3,2) & LEFT(A1,2)
 shanemacdonald Posts: 3, Reputation: 10 New Member #15 Dec 23, 2009, 11:06 AM
Can't seem to get the hextosng function to work with Office 2007. Are there any known issues with this?
 shanemacdonald Posts: 3, Reputation: 10 New Member #16 Dec 23, 2009, 11:08 AM
My post was with regards to the formula for converting 32 bit hexadecimal into decimal in EXCEL... Cheers, Shane
 JBeaucaire Posts: 5,377, Reputation: 5036 Software Expert #17 Dec 23, 2009, 11:33 AM

Were you going to post a workbook with the function installed in it and NOT working as expected? Do so, be sure to highlight the cells with the function(s) in use so I don't have to hunt for them.
 shanemacdonald Posts: 3, Reputation: 10 New Member #18 Dec 23, 2009, 12:11 PM
I saved, closed and reopened Excel - all seems good.

Thanks,

Shane
 kishorekumar88 Posts: 1, Reputation: 10 Junior Member #19 Dec 8, 2010, 05:46 AM
How to convert from Float number to 32 bit Hex ?
 besjon Posts: 1, Reputation: 10 Junior Member #20 Apr 25, 2011, 02:08 AM

## 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 containes 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...