1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Excell question

Discussion in 'Software' started by ManicMonkey, Sep 12, 2007.

  1. ManicMonkey

    ManicMonkey Kilobyte Poster

    325
    4
    32
    Ok being a fool here but i cannot remember for the life of me how to do this.

    Entering data into excel and i want to have a column down the left with an incrementing reference code.
    What im after is AA-AAAA-0000 with only the number incrementing each time.

    Anyone have any thoughts?
     
    Certifications: MCSE
    WIP: Exchange, Share point - MOM as well
  2. nugget
    Honorary Member

    nugget Junior toady

    7,796
    71
    224
    Enter the AA-AAAA-0000 into the cell. Select the cell, and then hold the ctrl and hover over the bottom right corner of the selected cell. You'll see a tiny + appear, click on the corner and drag down. When you let go you'll see the incremented number.
     
    Certifications: A+ | Network+ | Security+ | MCP (270,271,272,290,620) | MCDST | MCTS:Vista
    WIP: MCSA, 70-622,680,685
  3. r.h.lee

    r.h.lee Gigabyte Poster

    1,011
    52
    105
    ManicMonkey,

    Off the top of my head...

    A1=[Heading title]
    A2="AA-AAAA-"
    B2=0000
    A3="AA-AAAA-"
    B3=B2+1

    Then grab the solid square bottom right corner of cell B3 then drag it down until you've got enough numbers.

    Will this work for you?
     
    Certifications: MCSE, MCP+I, MCP, CCNA, A+
    WIP: CCDA
  4. ManicMonkey

    ManicMonkey Kilobyte Poster

    325
    4
    32
    Just got told the really silly simple answer:oops:

    AA-AAAA-0000 in cell 1
    AA-AAAA-0001 in cell 2

    select both cells and then drag using the corner of the box, excell works out th difference between teh two and then increments.
    DOH!


    Cheers for the answers though peeps :)
     
    Certifications: MCSE
    WIP: Exchange, Share point - MOM as well

Share This Page

Loading...