Enter in A1:

=ROW() and drag down ro A500

or:

Enter 1 in A1, 2 in A2, highlight both cell and copy down on the fill handle

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Paul" wrote in message
...
I want column "A" to be numbered 1 to 500