how do i print a page of consecutive numbers

G

Guest

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
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consecutive print numbers 3
Continuous page numbering when printing whole book 2
Excel Count of Consecutive Data 0
how to set page break for continuous numerical sheet printing 2
How do I in excel print consecutive numbers from one form? 1
consecutive page numbers of the same page 1
Sorting a list of numbers 4
Counting strings of consecutive numbers in a column 1

Top