Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading Zero in Hexadecimal?
Works from 0-9, but OOPS, I forgot to add that I need it for 0A-0F, too...
"JMB" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading Zero in Hexadecimal?
00-0F?
"0"&dec2hex(a1) since 0-15 will return a single character. Tony wrote: Works from 0-9, but OOPS, I forgot to add that I need it for 0A-0F, too... "JMB" wrote in message ... 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? -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading Zero in Hexadecimal?
That did it - thanks!
"Dave Peterson" wrote in message ... 00-0F? "0"&dec2hex(a1) since 0-15 will return a single character. Tony wrote: Works from 0-9, but OOPS, I forgot to add that I need it for 0A-0F, too... "JMB" wrote in message ... 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? -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading Zero in Hexadecimal?
Perhaps:
=IF(ISODD(LEN(DEC2HEX(A1))),"0","")&DEC2HEX(A1) "Tony" wrote: Works from 0-9, but OOPS, I forgot to add that I need it for 0A-0F, too... "JMB" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal to Hexadecimal | Excel Discussion (Misc queries) | |||
How do you sort a column with Hexadecimal data | Excel Discussion (Misc queries) | |||
Formula for converting Binary to Hexadecimal | New Users to Excel | |||
Hexadecimal to binary | Excel Discussion (Misc queries) | |||
adding hexadecimal numbers | New Users to Excel |