Leading Zero in Hexadecimal?

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

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?
 
Works from 0-9, but OOPS, I forgot to add that I need it for 0A-0F, too...
 
00-0F?

"0"&dec2hex(a1)
since 0-15 will return a single character.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hexadecimal to binary 5
format numbers in hexadecimal 1
Format cells for hexadecimal numbers 2
Max Hex characters set to ten? 1
Leading Zero 11
Format Cells for Hexidecimal (custom?) 1
Formatting cells as hexadecimal 2
Conversion of Dec numbers to Bin, Oct and Hex and visa versa 1

Back
Top