Autofill Hexidecimal numbers

dmc1129

New Member
Joined
May 2, 2002
Messages
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
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
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
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
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!
 
Upvote 0
1. Enter '1 into cell A1
2. Enter the formula, =DEC2HEX(HEX2DEC(A1)+1), into A2 and fill down as far as needed.
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,194
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top