Format the cell with a custom format, such as jn51000000
Then when you type a 1 in the cell it should be jn51000001, a 2 should
appear as jn51000002. And your formula need only be =A1+1

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

www.OfficeArticles.com


"MellowMe" wrote in message
...
I need a formula that will add 1 for each record of a reference number.
exaplme: my first reference number is jn51000001. I need a formula to
copy
and paste down a good 20,000 cells. I can't use =sum(a1+1) because of the
text in it.
I desparately need help on a formula that will work.