how do i print a page of consecutive numbers

K

Ken Barrie

trying to print a page full of consecutive numbers starting at 0001 and
going to 9999.

any help would be gret.

thanks
Ken
 
P

Pete_UK

You can put this formula in A1:

=ROW()

Use a custom format on this cell set to 00000. Then copy this formula
into A2:A9999.

Hope this helps.

Pete
 
K

Ken Barrie

Thanks pete, that did the trick.
take care
Ken

Pete_UK said:
You can put this formula in A1:

=ROW()

Use a custom format on this cell set to 00000. Then copy this formula
into A2:A9999.

Hope this helps.

Pete
Click to expand...
 
Top