Thanks:  0
Likes:  0

1. 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.

2. Have you tried to copy and paste?
Tom

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

4. 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

5. 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

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

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

8. 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.

9. 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!

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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•