binary conversion

  1. U

    VBA Copy Paste Data from Binary to XLXS

    Hi Gurus, Do you have any thoughts on how to code this. I have a binary file with data ranging to 1 million lines. I am planning to copy the data in xlxs version. The header to be use is same with what's in the binary for all sheets. Example: Open Binary File that contains 1.05 Million lines...
  2. S

    Very long Binary Number but Excel treats it as Decimal one

    Hello everyone! I am dealing with 23-bit long SRAM memory addresses. I copy the data from CSV file and split into column. all the data is in binary including one column containing 23-bit long binary number, for example, "10000000111100101010100". Excel treats this data as DECIMAL and represent...
  3. J

    Brain Teaser that I am having issues with

    Hopefully someone can help, I am looking to help with creating a VBA function to essentially "rebase a number" The function would have 2 inputs, the hex number to rebase and the new base. Public Function HEX2ANY(input1 As Integer, input2 As Integer) End Function If I were to do...
  4. C

    Decimal to Hexadecimal to Binary with a twist

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top