Results 1 to 4 of 4
  1. #1
    liner
    Guest

    Automatic number sequencing (2003)

    I would like to be able to have the following text generated automatically:

    This is number 1 of a series
    This is number 2 of a series
    ....etc.

    When I use { AUTONUM } I get the following
    This is number 1. of a series
    This is number 2. of a series

    How do I get AUTONUM to drop the dot following the number?

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Automatic number sequencing (2003)

    <P ID="edit" class=small>(Edited by jscher2000 on 30-May-08 19:08. First attempt wasn't entirely clear.)</P>Forget about the preformatted AUTONUM and LISTNUM fields and try SEQ. Each SEQuence field needs a name so it can be distinguished from other ones. For example, these --

    { SEQ MySouvenirsCollection }
    { SEQ MyTequilaCollection }

    -- can be used side by side in the same area of the document without interfering with one another:

    This is number { SEQ MySouvenirsCollection } of a series of souvenirs ==> 1
    This is number { SEQ MySouvenirsCollection } of a series of souvenirs ==> 2
    This is number { SEQ MyTequilaCollection } of a series of tequilas ==> 1
    This is number { SEQ MySouvenirsCollection } of a series of souvenirs ==> 3
    This is number { SEQ MyTequilaCollection } of a series of tequilas ==> 2

    If you copy and paste an SEQ field, it will not immediately renumber. Select it (or select all) and press F9 to update the numbering.

    Does this fit your needs?

  4. #3
    liner
    Guest

    Re: Automatic number sequencing (2003)

    Yes, it will do just fine. Just a quick question: Do I need to define { SEQ MySouvenirsCollection } at the start of the document, or can I simply add it as needed?

  5. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Automatic number sequencing (2003)

    The first occurrence of the field will start the numbering sequence at 1 (unless you explicitly specify otherwise). So simply insert the field where you need it.

Posting Permissions

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