Remember Me?

#1
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 3

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
 external usenet poster Posts: 2,062

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
 external usenet poster Posts: 3

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
 external usenet poster Posts: 35,218

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
 external usenet poster Posts: 3

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
 external usenet poster Posts: 2,062

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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Sean Timmons Excel Discussion (Misc queries) 6 January 5th 07 11:45 PM lion99 Excel Discussion (Misc queries) 2 November 10th 06 08:14 PM Teraawete Tekena New Users to Excel 1 March 23rd 06 08:14 AM [email protected] Excel Discussion (Misc queries) 5 March 4th 06 06:45 PM Dave New Users to Excel 3 February 10th 06 09:46 AM

All times are GMT +1. The time now is 09:19 AM.