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" <[email protected]> wrote in message
news:[email protected]...
> please tell me how to consecutively numbers in a column such as a
consecutive
> invoice numbers