hex

I have a file produced by a proprietary third party application that is effectively a CSV with one specific exception: the first 3 rows do not follow a tradtional CSV format. I can open the file in Excel, and the file represents itself correctly. If I open, hit save (changing nothing) and then...

Hi, I am new to HMAC, I need to perform HMAC SHA1 using some HEX input data and TEXT key to get some HEX output data, I have found the below VBA code to process some TEXT input data and get Base 64 output data and this works fine, if I use it in Excel and check one some website as below, I get...

Okay this is what I am trying to do. I need to take a Hex value and have it returned in reverse Byte pairs as in the following diagram For instance the top line (480000074B26E42D) being the original hex value, then reversing it so that the outcome = 2D E4 26 48 07 00 00 48 I have tried using...

Hello all! I am trying to get more into making UserForms and the limited color choice is starting to bother me. Is there a way to convert hex color codes to what ever this is, &H80000012&?

Hello to all, I want to write the hexadecimal values to a binary file in order they look the same when I open in hex editor. My current code is this: Sub Write2Binary() Dim i As Integer Dim nFileNum As Integer Dim sFilename As String sFilename = "D:\OutputPath\Test.bin" strBytes = "F3...

Hello all, I ave just completed converting decimal to binary without the use of DEC2BIN. However now I am moving onto converting this concatenated 8 bit binary number into Hex, without the use of BIN2HEX. What I have done so far is set up a vertical table with two columns, one with 16 values...

I saw your example converting hex to ascii "=CHAR(HEX2DEC("4A"))". I would like to know how to convert a string of hex to ascii. There is example: 5238304d33335446462 and convert to R80M33TFF

Hi, I need to be able to convert the number that Interior.Color returns to an RGB Hex Code like #005473 or #FF00EE , etc. Any ideas? Thanks.

Hi all, I am new to Power Query, I needed to convert Decimal to Hex, here is my solution using recursive approach. It is working like a charm, however, I have no idea if it is an optimal solution. So, comments are appreciated: (input as number, optional string as nullable text) => let...

I have a VBA conditional function I hacked together (I'm a noob) that does a hex 'AND" function on a 36-bit value in a cell with another 36-bit value. This result is then passed though another function (total hack) that looks for logical '0' other wise it assumes logic '1'. The second part is...

I teach computer forensics classes and we have the need for a formula that will determine if any length hex number (typically 2,3, or 4 bytes) is negative and, if so, convert that number to its negative decimal equivalent. I have been able to do that with the following formula (cell E5 contains...

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.