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