Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Autofill Hexidecimal numbers

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have you tried to copy and paste?
    Tom

  3. #3
    New Member
    Join Date
    May 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #5
    New Member
    Join Date
    May 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #6
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  7. #7
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  8. #8
    New Member
    Join Date
    May 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #9
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!

    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  10. #10
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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