+ Reply to Thread
Results 1 to 5 of 5

autonumber

  1. #1
    Hardy
    Guest

    autonumber

    Is there a way of getting a autonumber column to start at a particular value?
    eg 950

  2. #2
    Ron Coderre
    Guest

    RE: autonumber

    I'm guessing that you are asking a MS Access question....

    If that's true...I think this site has what you're looking for:
    http://www.databasedev.co.uk/reset_autonumber.html


    Does that help?

    ***********
    Regards,
    Ron


    "Hardy" wrote:

    > Is there a way of getting a autonumber column to start at a particular value?
    > eg 950


  3. #3
    Hardy
    Guest

    RE: autonumber

    No the person wants it in excel (for some strange reason!)

    the formula is =IF(A2<>"",ROW(B1),"") whish starts the autonumbers at 1 but
    they would like it to start at 950?

    "Ron Coderre" wrote:

    > I'm guessing that you are asking a MS Access question....
    >
    > If that's true...I think this site has what you're looking for:
    > http://www.databasedev.co.uk/reset_autonumber.html
    >
    >
    > Does that help?
    >
    > ***********
    > Regards,
    > Ron
    >
    >
    > "Hardy" wrote:
    >
    > > Is there a way of getting a autonumber column to start at a particular value?
    > > eg 950


  4. #4
    Roger Govier
    Guest

    Re: autonumber

    Hi

    Then just add 949 to the start value.
    =IF(A2<>"",ROW(B1)+949,"")

    Regards

    Roger Govier


    Hardy wrote:
    > No the person wants it in excel (for some strange reason!)
    >
    > the formula is =IF(A2<>"",ROW(B1),"") whish starts the autonumbers at 1 but
    > they would like it to start at 950?
    >
    > "Ron Coderre" wrote:
    >
    >
    >>I'm guessing that you are asking a MS Access question....
    >>
    >>If that's true...I think this site has what you're looking for:
    >>http://www.databasedev.co.uk/reset_autonumber.html
    >>
    >>
    >>Does that help?
    >>
    >>***********
    >>Regards,
    >>Ron
    >>
    >>
    >>"Hardy" wrote:
    >>
    >>
    >>>Is there a way of getting a autonumber column to start at a particular value?
    >>>eg 950


  5. #5
    Gord Dibben
    Guest

    Re: autonumber

    Hardy

    =IF(A2<>"",ROW(B950),"")


    Gord Dibben Excel MVP

    On Thu, 24 Nov 2005 07:46:30 -0800, "Hardy" <Hardy@discussions.microsoft.com>
    wrote:

    >=IF(A2<>"",ROW(B1),"")



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1