# autonumber

1. ## autonumber

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

2. ## 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. ## 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. ## 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. ## 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),"")

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

#### 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