excel formulas
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
"lost in excel" wrote in message
...
how do i track 6000 raffle tickets in intervals of 10. There has to be a
formula rather than entering the numbers in manually!
|