how do i print a page of consecutive numbers

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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

Continuous page numbering when printing whole book 2
how to set page break for continuous numerical sheet printing 2
Consecutive print numbers 3
Excel Count of Consecutive Data 0
is it possible to print multiple pages with different numbers 5
Any (6) consecutive entries 4
consecutive numbering 1
How do I in excel print consecutive numbers from one form? 1

Back
Top