From decimal values in Excel to binary / hex Intel format

Thread Starter

atferrari

Joined Jan 6, 2004
3,374
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:
 

SigmaCeq

Joined Jul 30, 2009
19
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.
 
Top