Thread: Leading Zero in Hexadecimal?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JMB JMB is offline
external usenet poster
  
Posts: 2,062
Default Leading Zero in Hexadecimal?
This appears to work okay:

=TEXT(DEC2HEX(A1),"00")

"Tony" wrote:

I'm using the DEC2HEX function to convert decimal numbers in cells to hex numbers.

For Hex 00 to 09, how do I format the cells so that there is a leading zero?




Reply With QuoteReply With Quote