hexadecimal

Dear All, I am trying to convert a hexadecimal string eg <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>EAAA863573781B which should return <style type="text/css"><!--td {border: 1px solid #ccc;}br...

Hi Friends, Here is the data and what I am trying to extract I want to extract words like Hexadecimal to character" which is abbreviated as X2C I am able to extract text between characters "(" AND ")" but not full meaning/form of abbreviated word. Hexadecimal to character (X2C) is a...

I am trying to write a macro that converts a decimal number into a hexadecimal using Do Until-loop and select case here is what I have so far when I run it the computer freezes up Sub HexConverter() Dim L As Double Dim K As Integer Dim N As Double Dim R As Double Dim A As Double Dim P As...

I need to be able to convert big hex numbers into decimal numbers. The problem that I have with this is that when you put a hex number that includes letters excel considers it text. And if the number is too big, you can't convert it to decimal format, and when you try to, it comes up with the...

What I want to be able to do is basically the same thing as opening up a file in a hex editor and then copying all of the hex data into a cell into a spreadsheet. The reason why I can't do that is because some of the files that I will be using have to much data to fit in my clipboard. popcornrulez

This formula works but only up to 10 bits: =DEC2HEX(HEX2DEC($A$1)+ROW()-1,10) If I add two bits and change the length to "12" it doesn't work. Help!!

Hi, I had used the DEC2HEX to convert a column of decimal numbers anywhere from 0 to 1023. It was ok and I got values from 000 to 3FF corresponding to 0000 0000 0000 and 0011 1111 1111 in binary. My problem now is when it is from -1 to -1023. The values I got are from FFFFFFFFFF to...

Hi all I am having some issues in passing Hex numbers to a function: the call which is showing a syntax error is this SetLabel FormControls.lblHeader, 2, iBarSidePad, (iFormHeaderHight - 2), iBarWidth, _ "Header", &H999999, &HO00000 the function itself is this: Private Function...

I am using excel to do quick analysis on Ethernet Packet Data I have read VBA for dummies and while it was kind of helpful It really wasnt what I needed It would be incredibly usefule to import the data (in one large cell) into a string and label it as an actual hex valued string . I do NOT...

Is there any way to get Excel 2007 to recognize a hex number using the 0x... format? Hex numbers in quotes "deadface" seems really useless.

Is there a way to automatically format the text color, and fill color based on a hex code or palette number. For example, #376091, #953735, #C5BE97, #FFCC99. I'm hoping to automatically format based on this color number. Is it possible?

This will proabably be an easy one for somebody... THe BackColor property on a UserForm is "&H00CFF3FF&" . Can someone please explain what that number means and/or what format it is in. :confused: I need to match that color and I am color-blind so I rely on the color values to help me do...

I have 5 cells with a Hexadecimal in it, on the 6th cell, I would like to have a Hexadecimal checksum. I have tried this: =dec2hex(hex2dec(H8))+(hex2dec(I8))+(hex2dec(J8))+(hex2dec(K8))+(hex2dec(L8)) but it doesn't work, any help or pointers would be greatly appreciated!!!! Thanks!!! Scott

I have a table of inventory. Colors down the size, Sizes across the top. I'm trying to create a macro that "prepares" the table in a certain way; so I can then make a GIF or JPG out of it, and post it on my Ebay listings online to show a (perhaps even real-ish time) image of my inventory...

Hi Mr Excel, I am into a problem where I need to subtract two 128 bit Hexadecimals values, Can I do that with Excel. Regards, Umair