consecutively number cells in a column range

please tell me how to consecutively numbers in a column such as a consecutive
invoice numbers

Type a 1, a 2, and a 3 in the first 3 cells. Select and drag down.
Alternatively, if you don't want them to show in A until data is entered in
B, you could do something like this:
Put 1 in A2 under the heading (in A1) Invoice Number.
Then, in A3, put =if(isblank(b2),"",a2+1)

*******************
~Anne Troy

www.OfficeArticles.com


"prissy2" <prissy2@discussions.microsoft.com> wrote in message
news:E55FE311-AC68-4D8B-B4F7-47C54F70981F@microsoft.com...
> please tell me how to consecutively numbers in a column such as a
consecutive
> invoice numbers