HELP - to enter numbers 001, 002, 003 into cells

Discussion in 'Microsoft Excel Discussion' started by Pointer, Jun 30, 2004.

  1. Pointer

    Pointer Guest

    I want to enter numbers from 001 to 999 into cells formatted as text.
    How can I without typing 001, 002, 003, etc individually into each
    cell?
     
    Pointer, Jun 30, 2004
    #1
    1. Advertisements

  2. Pointer

    JE McGimpsey Guest

    Format column A as Text. In A1, enter 001. Drag the fill handle down as
    far as necessary - XL will increment the number.

    In article <>,
    Pointer <> wrote:

    > I want to enter numbers from 001 to 999 into cells formatted as text.
    > How can I without typing 001, 002, 003, etc individually into each
    > cell?
     
    JE McGimpsey, Jun 30, 2004
    #2
    1. Advertisements

  3. Pointer

    Pointer Guest

    I knew the trick but never though it would work in cells formatted as
    text. Thanks JE.

    Pointer

    ------

    On Wed, 30 Jun 2004 00:02:08 -0600, JE McGimpsey
    <> wrote:

    >Format column A as Text. In A1, enter 001. Drag the fill handle down as
    >far as necessary - XL will increment the number.
    >
    >In article <>,
    > Pointer <> wrote:
    >
    >> I want to enter numbers from 001 to 999 into cells formatted as text.
    >> How can I without typing 001, 002, 003, etc individually into each
    >> cell?
     
    Pointer, Jun 30, 2004
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Richard

    How do I get a cell to show a number like 001?

    Richard, Apr 21, 2004, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    317
    Ken Wright
    Apr 21, 2004
  2. Pointer

    HELP - to enter numbers 001, 002, 003 into cells

    Pointer, Jun 30, 2004, in forum: Microsoft Excel Discussion
    Replies:
    0
    Views:
    219
    Pointer
    Jun 30, 2004
  3. sybmathics

    getting numbers in cells into formula

    sybmathics, Dec 6, 2005, in forum: Microsoft Excel Discussion
    Replies:
    6
    Views:
    141
    sybmathics
    Dec 6, 2005
  4. texasphil

    Numbers in cells not responding to Format Cells

    texasphil, Mar 19, 2006, in forum: Microsoft Excel Discussion
    Replies:
    3
    Views:
    681
    stfarrar
    Mar 19, 2006
  5. Guest

    How to convert numbers using dots into numbers using commas

    Guest, Dec 5, 2006, in forum: Microsoft Excel Discussion
    Replies:
    3
    Views:
    520
    Guest
    Dec 9, 2006
Loading...

Share This Page