convert decimal to 16 bit hex

T

tsobiech

The excel DEC2HEX function converts decimals to 40 bit hex values, I would
like to convert to 16 bit values. Is there any way to do this?
 
J

Jerry W. Lewis

=RIGHT(DEC2HEX(number,4),4)

should even preserve the range checking.

Jerry
 
T

tsobiech

Yes, I had already made that modification, but you put me on the right path
initially.

Thank You!
 
Top