In Excel cells A1 and A2, I have the following hexadecimal numbers: 04cf and 04fb which are 1231 and 1257, respectively.
I am trying to convert A1 and A2 to hexadecimal and then add the two to obtain 2488. In B1, I enter =SUM(HEX2DEC(A1:A2)) but this returns an error.
It looks like I need to have a separate section devoted to the decimal forms of A1 and A2, and then I can add the numbers within that section together. The thing is I have a lot of data and it would take up a lot of space on the spreadsheet. I'm looking to see if it's possible to do this more cleanly?
Thanks a bunch.