| 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 | |||
Linear Mode
