View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tony Tony is offline
external usenet poster
 
Posts: 3
Default Leading Zero in Hexadecimal?

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?