When I try to use the functions dec2hex or bin2hex they just return the decimal number (ie they behave like dec2dec or bin2dec). I have tried several different formats per the help page but I can't get either function to return a hex value. Is there some kind of trick to make these work?
iMac Line (2012 and Later)
Thanks. Pilot error. I had the cells formatted as Number. When I changed it to Automatic it works as expected. FYI, I was trying to be clever and add a 0x in front of the hex value. The only choices for a custom format are Number, Date & Time, or Text, and Number doesn't support anything but decimal. Thats what I get for trying to be clever. Oh well, thanks for the quick reply.
Thanks. Pilot error. I had the cells formatted as Number. When I changed it to Automatic it works as expected. FYI, I was trying to be clever and add a 0x in front of the hex value. The only choices for a custom format are Number, Date & Time, or Text, and Number doesn't support anything but decimal. Thats what I get for trying to be clever. Oh well, thanks for the quick reply.
If you are not using the hex values for anything but to look at (i.e., you do not need them to be actual numbers in downstream formulas), you can make them into text by prepending or appending some text to them, like the "0x".
="0x"&DEC2HEX(...)
formatted as automatic or text
Here's what I get with DEC2HEX().
=DEC2HEX(A2,convert-length)
Or, if your region uses , as a decimal separator:
==DEC2HEX(A2;convert-length)
That looks right. Are you getting something. different?
SG
SG
mctoons wrote:
I was trying to be clever and add a 0x in front of the hex value.
You can do that with the second parameter of the function, e.g.
SG
Problem with functions in Numbers
