Nathan, in your cells try putting =Row() and see if that will work for you

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Nathan Elphick" wrote in message
...
I want to set up a template with numbers, say 1 - 10 in alternate cells,
say
A1, A3, A5 - A19 so that if you add/or delete a row the numbered cell is
added or deleted automatically thus the numbers always remain in numerical
order. Can this be done?