Autofill Hexidecimal numbers

dmc1129 · May 3rd, 2002, 06:46 PM

I am having trouble creating spreadsheet with hex numbers by draging the handle.
I can convert the numbers using the dec2hex fourmula but can't use the drag to extend the series.
Thanks for your help

Tom Schreiner · May 3rd, 2002, 06:51 PM

Have you tried to copy and paste?
Tom

dmc1129 · May 3rd, 2002, 06:57 PM

No I didn't, would I copy and paste the whole series?

Tom Schreiner · May 3rd, 2002, 07:03 PM

Yes.
A copy and paste for a formula should yield the results you are looking for. Eventhough, the fill handle grab-drag should work. I don't know why it is not...

Maybe paste a sample of your problem and I'll try it out myself...

Tom

dmc1129 · May 3rd, 2002, 07:10 PM

1
2
3
4
5
6
7
8
9
A
B
C
D
E
F
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
A
B
C
D

Ivan F Moala · May 3rd, 2002, 10:42 PM

Why not just drag the Dec numbers THEN
convert to hex after, or have I missed
something ??

Yogi Anand · May 3rd, 2002, 10:50 PM

Ivan:
That's simple, straightforward, and practical approach!

dmc1129 · May 4th, 2002, 05:31 PM

Thanks for the help, but I am new to excel and not sure how to do it. I tried to copy and paste the formula from 1 to F in hex and it just repeated the formula and not count up.

Yogi Anand · May 6th, 2002, 10:11 AM

Quote:

On 2002-05-04 16:31, dmc1129 wrote:
Thanks for the help, but I am new to excel and not sure how to do it. I tried to copy and paste the formula from 1 to F in hex and it just repeated the formula and not count up.

I hope you have got it resolved by now ... otherwise here is a step by step approach:
1. Create a series starting from cell A1, to say A32 -- you could start the series with 1 in cell A1 in column, and use a step value of 1 with an ending value of 32
-- now this series is in decimal numbers

2. clivk in cell B1 and write the following formula to convert the decimal number in cell A1 to a hexadecimal number in B1

=DEC2HEX(A1)
and copy ythis ato all cells from B2:b32

now all the cells in B1:B32 are in hexadecimal notation.

This way you have created a series of numbers in hexadecimal indirectly.

Hope This Helps!

Mark W. · May 6th, 2002, 03:05 PM

1. Enter '1 into cell A1
2. Enter the formula, =DEC2HEX(HEX2DEC(A1)+1), into A2 and fill down as far as needed.

May 3rd, 2002, 10:42 PM	#6
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	Why not just drag the Dec numbers THEN convert to hex after, or have I missed something ?? __________________ Kind Regards, Ivan F Moala From the City of Sails

May 3rd, 2002, 10:50 PM	#7
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Ivan: That's simple, straightforward, and practical approach! __________________ Regards! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC www.energyefficientbuild.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 3rd, 2002, 06:46 PM	#1
dmc1129 New Member Join Date: May 2002 Posts: 4	I am having trouble creating spreadsheet with hex numbers by draging the handle. I can convert the numbers using the dec2hex fourmula but can't use the drag to extend the series. Thanks for your help

May 3rd, 2002, 06:51 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Have you tried to copy and paste? Tom

May 3rd, 2002, 06:57 PM	#3
dmc1129 New Member Join Date: May 2002 Posts: 4	No I didn't, would I copy and paste the whole series?

May 3rd, 2002, 07:03 PM	#4
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Yes. A copy and paste for a formula should yield the results you are looking for. Eventhough, the fill handle grab-drag should work. I don't know why it is not... Maybe paste a sample of your problem and I'll try it out myself... Tom

May 3rd, 2002, 07:10 PM	#5
dmc1129 New Member Join Date: May 2002 Posts: 4	1 2 3 4 5 6 7 8 9 A B C D E F #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! A B C D

May 4th, 2002, 05:31 PM	#8
dmc1129 New Member Join Date: May 2002 Posts: 4	Thanks for the help, but I am new to excel and not sure how to do it. I tried to copy and paste the formula from 1 to F in hex and it just repeated the formula and not count up.

May 6th, 2002, 03:05 PM	#10
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	1. Enter '1 into cell A1 2. Enter the formula, =DEC2HEX(HEX2DEC(A1)+1), into A2 and fill down as far as needed.