hex - Decimal to hexadecimal upto two bytes in Excel -

hex - Decimal to hexadecimal upto two bytes in Excel -

dec2hex converts number default number of bytes (in case ms office standard 10 -upto 5 bytes), example:

dec2hex(number) = fffffffb8a.

is there way trim 2 bytes? = abcd.

number decimal integer.

=dec2hex(mod(-1142,hex2dec(10000)),4)

or

=dec2hex(mod(-1142,65536),4)

or

=right(dec2hex(-1142,4),4)

excel hex