Limit leading Fs in Excel DEC2HEX with negative numbers?
I want to convert decimal numbers to 8 bit 2s complement hex. When I do DEC2HEX(1,2) I get 01 which is perfect. When I do DEC2HEX(-1,2) I get FFFFFFFFFF which is way too many. How do I limit the ...