From decimal values in Excel to binary / hex Intel format

Discussion in 'Programmer's Corner' started by atferrari, Jul 29, 2009.

  1. atferrari

    Thread Starter AAC Fanatic!

    Jan 6, 2004
    Have to burn massive data to two eeproms which I will produce in Excel in decimal notation.

    A friend will do for me, requesting it in binary or hex Intel format.

    Can anyone detail the process to go from the .xls file to both options (binary or hex) ready to be passed to him?

    I discarded anything done by hand other than producing the data itself (prone to error - and boring).

    JUst in case I know nothing about common tools for people programming PCs in any form. Sorry, just assembler for PICs :mad:
  2. SigmaCeq


    Jul 30, 2009
    In Excel, there are functions called for converting from binary to hex to decimal. For example, DEC2HEX converts from decimal to hex. DEC2BIN converts from decimal to binary.

    For these functions to work, you must enable the Analysis ToolPak. Go to Tools-> Add-Ins. Then select the checkbox next to "Analysis ToolPak." If you don't see "Analysis ToolPak," you'll need to download it off the MS Office website.
  3. davitz38

    New Member

    Dec 30, 2009
    Hi guys,
    In case you need to convert a hex value to binary, try this hex to binary converter
    Pretty useful!