Thread: convert decimal to 16 bit hex
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jerry W. Lewis Jerry W. Lewis is offline
external usenet poster
  
Posts: 837
Default convert decimal to 16 bit hex
=RIGHT(DEC2HEX(number,4),4)

should even preserve the range checking.

Jerry

"Jerry W. Lewis" wrote:

=RIGHT(DEC2HEX(number),4)

Jerry

"tsobiech" wrote:

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?
Reply With QuoteReply With Quote