excel formulas

L

lost in excel

how do i track 6000 raffle tickets in intervals of 10. There has to be a
formula rather than entering the numbers in manually!
 
P

Pete_UK

Type this into cell A1:

0001 - 0010


and then in A2 put this formula:

=TEXT(LEFT(A1,4)+10,"0000")&" - "&TEXT(RIGHT(A1,4)+10,"0000")

Copy this formula down the column until you reach 6000 - it will give you
values like this:

0011 - 0020
0021 - 0030
0031 - 0040
0041 - 0050


Is this what you want?

Hope this helps.

Pete
 
D

Dave Peterson

Another one:

Put this in a cell:
=TEXT((ROW(A1)-1)*10+1,"0000")&" - "&TEXT(ROW(A1)*10,"0000")
And drag down 600 rows

Then select that range and convert it to values.
(edit|copy followed by edit|paste special|values)
 

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

Random ticket number for raffle 2
excel maths 6
Count by 10 1
Add a set number to a random entered number 1
I would like to create raffle tickets in Excel, How? 1
HELP!! New to Excel. Need complex SUMIF. 0
How Do I INsert Numbers Into a Raffle Ticket Template 1
Formula text in woorksheet cell 2

Top