Select the Text Tool (T) and start dragging a text box that will wrap around the whole ticket including the crop marks. This is very important since the Data Merge will automatically calculate the duplication. Then open up the Text Frame Option (Command + B) and set the Inset spacing to 1p4 for the top and 1p8 for the left. Of course, you can place the text for the numbers anywhere you like. I set the numbers to a small text.
Hello, I'm looking for a way to quickly find what numbers are missing in column B. I can sort them ascending, but how do I find if there are missing numbers? 1 2 3 5 6 7 9 I need to know 4 and 8 are missing. Thank you. One way: select B2:Bx. Choose Format/Conditional Formatting... CF1: Formula is =(B2-B1)>1 Format1: / or, without sorting, select column B (with B1 active): CF1: Formula is =AND(B1>MIN(B:B),COUNTIF(B:B,B1-1)=0) Both CF's will activate if there are missing numbers before them. In article <28706E9E-2624...
In the Republic of Ireland, junction numbers have existed since the opening of the first section of the M50 motorway in 1990, however due to the short length of Irish motorways until the early 2000s they were normally ignored by the general public. They are beginning to come into popular usage now, and since 2005 have been given greater prominence on road signs. With the development of the inter-urban motorway network under the National Development Plan and Transport 21, the National Roads Authority has adopted a numbering scheme for the inter-urban roads that will see Junction 1 being designated as that road's junction with the M50 in most cases. This has meant renumbering of existing junctions on some motorways, most notably the M7 motorway. Non-motorway dual carriageways forming part of major inter-urban roads also have junction numbers, however only grade-separated interchanges are numbered.
The ticket numbering problem seems solved, if awkwardly. But what about linking automatic numbering of text references to a figure (e.g. “see fig.101″) to a legend of that figure (e.g. Fig. 101 shows….”)? Is this quite beyond InDesign CS3? If it is solvable the solution isn’t mentioned in any CS3 book I have managed to get hold of, nor is it dealt with in the CS3 Help facility as far as I can see, nor were the speakers at a recent Adove CS3 Workshop able to solve it. Please advise this frustrated book author!

You could stop there and just copy those little bits of text all through your document. But no, we want to make this really, really easy! So we’re going to set up some AutoText entries. What that’s going to do for you (if you’re using Microsoft Word 2010 or above — if you use version 2007, see below for some caveats) is allow you to type the first four letters of your SEQ name and have Word offer to complete the phrase for you, complete with the incrementing number courtesy of the sequence field code we set up earlier.


I have done this twice now, getting flustered. The ticket part the person keeps has the correct sequential number on it, but the side that we keep has the same number on it for the whole page. What part am I missing, at first I did not uncheck the box, but this time I did but have the same number on the stub side that we keep with the person’s name, etc
Please tell me there is a way to accomplish this.  As stated, if two users launch the initial submission form with the lookup field populated with P1234 for example, the first user to submit get the number, and the second user now has started there purchasing with a duplicated/invalid number.  Can we increment the field on submission load?  Also, the ability to instead show the purchasing number on event completion doesn't work either, too bad.
It sure is possible! Numbering and Section options are available in the Pages Panel menu. These options allow you to define what page starts a section and how it should be numbered. Insert a Current Page Number marker (Type>Insert Special Character>Markers>Current Page Number) in a text frame on a page or master page (recommended), select the first page of your section, open the Numbering and Section Options dialog, and enter 200 in the Start Page Numbering at: field. Hope this helps!
when I assign a heading level to a figure, all the other figures at different heading levels change to the level I assigned the new figure. ie, I have a figure under chapter heading level 3, then I have a figure in the next section under chapter heading level 1. When I select chapter heading numbering for header 1, all the other figures in my document go to that level instead of maintaining their specific level…help?
Does anybody have a way of formatting the phone numbers in Outlook 2003 so that they appear as xxx yyy zzzz that is no dashes, no parentheses? If I am going to synch to my PDA I want the numbers as short as possible and, to me, as readable as possible. Steve No. Masking of phone numbers is hard coded and based on your default dialing location. -- Russ Valentine [MVP-Outlook] "Steve E." wrote in message news:2dd601c48eb8$3ff4a1e0$a601280a@phx.gbl... > Does anybody have a way of formatting the phone numbers in > Outlook 2003 so that they appear as x...
I have screen shots of what I have in my db, where can I send it to you (it is in word format) so that you can take a look at it to see what I am doing wrong. I took a screen shot of what is listed for the button and I took a screen shot of the text box Job No. I don’t know how to bound anything other than put the code behind the button and putting the Job_No in the code as you stated. I understand what you are saying, but I thought if I put the text box name Job No in the code behind the button then it would be bound to my table with the Job No field. Heeeelllllppppp!!!! I am sorry that I can’t seem to grasp this….but appreciate all of your help!
One solution is to format the heading with the style and follow it with a hidden paragraph mark. You should format the text in the next paragraph with a style that is not included in the Table of Contents. A hidden paragraph mark keeps the text together on one line when it is printed, even though it is actually two separate paragraphs. The Table of Contents command picks up only those paragraphs with heading styles and places them into the Table of Contents.
Select the Text Tool (T) and start dragging a text box that will wrap around the whole ticket including the crop marks. This is very important since the Data Merge will automatically calculate the duplication. Then open up the Text Frame Option (Command + B) and set the Inset spacing to 1p4 for the top and 1p8 for the left. Of course, you can place the text for the numbers anywhere you like. I set the numbers to a small text.
You want to do this because your document is long and readers can’t easily find the tables/figures they want as numbers like Table 34 are meaningless unless you find the table captions before/after ‘Table 34’. By changing the numbering sequence to include the chapter numbers, your readers will have guideposts to aid their search — if they are in Section 5, they will know that Table 3.2 is back in Section 3 and is the second table in that section.
A sequence space is a vector space whose elements are infinite sequences of real or complex numbers. Equivalently, it is a function space whose elements are functions from the natural numbers to the field K, where K is either the field of real numbers or the field of complex numbers. The set of all such functions is naturally identified with the set of all possible infinite sequences with elements in K, and can be turned into a vector space under the operations of pointwise addition of functions and pointwise scalar multiplication. All sequence spaces are linear subspaces of this space. Sequence spaces are typically equipped with a norm, or at least the structure of a topological vector space.

You can define a section prefix to label section pages automatically. For example, if you specify A– for Section Prefix on page 16 of a document and include the section prefix, the page will appear in the table of contents or index as A–16. Text you type for a section marker appears when you choose Type > Insert Special Character > Markers > Section Marker.
My issue is trying to create small dot labels or equivalent to make up sequential alpha numeric labels to identify each individual item that I have in my shop, retrospectively. I have possibly 6-8thousand individual items that need coding for stock take purposes yet I can find no outlet that supply such thing. Do you have any suggestions. My line is antiques/collectables, predominantly china with items ranging in size from 2-3cm to 5/600cm. I would be most grateful for any solutions or suggestions. Best regards. Pete.
Despite its difficulties and drawbacks Word's automatic numbering can be harnessed. The best method I have seen for doing that is with outline numbering as explained by MVP Shauna Kelly in: Outline numbering in Microsoft Word. This takes a good bit of work to get it set-up, but if you get it set up in a template it is well worth the effort and most of your automatic paragraph numbering issues will be resolved.

Some drawbacks to this feature are that you lose a little control when you are typing. Word formats for you and some users do not like this. Also, on certain items, you will get a number when you do not expect or need one. For example, you have an attorney whose name begins with an initial (A. George Smith). When you type the name and press ENTER, the first initial "A." converts to an automatic number.
I know that PrintShopMail will do it, but I was wandering if there was a less expensive solution out there so that I could get numbered tickets (usually 4-up) right off the Xerox. I just want to avoid having to go the the Windmill after trimming and doing it the old fashion way. There is a tiny little copy shop here in town that is doing it, and am willing to bet that they are not using PrintShopMail, but I'm also not going to ask them to share their methods with a competitor. There has to be cheaper solution. I know that I can do it with auto page numbering in Indesign, but that means I can only print raffle tickets 1-up which wont work.

Number Pro does not create your raffle ticket or document it just allows an easy way to  number them. Check out Number Pro, take a look at the demo videos and even try the demo of Number Pro to see how it works. Number Pro is a cloud based application meaning there is no download of the application. We access the application online in the members area. They offer a three year membership with unlimited use.
You could stop there and just copy those little bits of text all through your document. But no, we want to make this really, really easy! So we’re going to set up some AutoText entries. What that’s going to do for you (if you’re using Microsoft Word 2010 or above — if you use version 2007, see below for some caveats) is allow you to type the first four letters of your SEQ name and have Word offer to complete the phrase for you, complete with the incrementing number courtesy of the sequence field code we set up earlier.
The Artifact ID should NOT be your PK. There is no reason for it to be and to try and use it as such will be a headache. A primary key is simply a unique identifier for a record. Many purists will tell you that users should never see the PK and in your case, I would recommend that. Use an Autonumber as you PK and you can use that as your corresponding Foreign Key in related records. To prevent duplication you can make the combination of Collection Point ID and Artifact ID a unique, multi-field index. Then display the combination as I indicated where you need to show the user a record ID. This is all explained int he blog.
To include numbering prefixes from higher levels, enter text or click at the start of the Number box and choose Insert Number Placeholder and then select a Level option (for example, Level 1), or enter ^ and then the list level (for example, enter ^1). In a list with first levels numbered 1, 2, 3, and so on, and second levels numbered a, b, c, and so on, including the first-level prefix in the second level renders second-level numbers as 1a, 1b, 1c; 2a, 2b, 2c; 3a, 3b, 3c.
@Andy: I’m sorry that I sounded dismissive. That wasn’t my intent. Rather, I was just admitting that I had no idea why someone using CS3 would not see the dialog boxes as they are shown above. If you’re using CS2, they would be significantly different. But the second part of the tip (where I show the numbering dialog boxes) relies on CS3 or later. If you are using CS3 or CS4 and you don’t see that dialog box, feel free to email me at david [at] indesignsecrets [dot] com and send me a screen shot of what you are seeing.

I normally use "Data Merge" in InDesign and use Excel (or something like it) to generate the list of numbers for me. You would copy the numbers into a text file so that InDesign can read them as the merge data source. Note that you would have one ticket on the page and then let InDesign set the other tickets on the page (you can tell the Data Merge control panel about spacing).


I have been generating 150-400 page reports with multiple lists in tables. Word's auto numbering would only go so far in applying sequential numbering but then it just stops and I could not use it any more. I had to manually type in the numbered list which was quite annoying and very time consuming. Then I came across your Word Tip. Awesome! It worked. Thanks so very much.

2. Yes, The code should be entered using CodeBuilder. Where you enter it depends on how and when you want to trigger the generation of the next number. If you want to use a button, that works. And no, you don’t use 000 in the NZ() function. If you want to DISPLAY at least 3 digits with leading zeros, then you do that in the Format function. Note, though, you will need to change that when you hit 1000 POs.
You could stop there and just copy those little bits of text all through your document. But no, we want to make this really, really easy! So we’re going to set up some AutoText entries. What that’s going to do for you (if you’re using Microsoft Word 2010 or above — if you use version 2007, see below for some caveats) is allow you to type the first four letters of your SEQ name and have Word offer to complete the phrase for you, complete with the incrementing number courtesy of the sequence field code we set up earlier.

I’m quite inclined to let the printer add the numbers. Less file size for me, less plates for me. I recently sent an invite to a digital printers, I offered to lay it up with all the names, they rejected the idea and said they could merge the names in as it printed. I guess it’s down to what you’re going to use it for. But if you’re going to print them yourself then by all means, if it’s going to a printer, best to check with them before you send anything definite over.


LION has an economy line, standard-duty numbering machines in both the 5 wheel & the 6 wheel model. As with the heavy-duty line, these automatic numbering machines are also made from one-piece hardened die-cast metal frame and wheels to assure trouble free operation. This self inking numbering machine is ideal for sequential numbering operations to use as a date and number stamp, serial number stamp, inspection stamp and etc. Best choice for the budget conscious users looking for standard quality, durability and low cost.
In this system, the third number (instead of the second) denotes a minor release, and a fourth number (instead of the third) denotes bug-fix/revision releases.[23] Because the first number is always 10, and because the subsequent numbers are not decimal, but integer values, the 11th major version of OS X is labeled “10.10” (rather than 11.0). This number scheme continues above point-10, with Apple releasing macOS 10.13 in 2017.[24]
In the example I explained, I was using a list, but did it with un-linked text boxes using “continue from previous number” and “continue numbers across stories.” I’m guessing that there is no way to tell InDesign that even though there are 4 text boxes on the page, that there are two different lists? I’d probably have to just create two threaded stories for that scenario to work.
If you’re a self-taught InDesign user, you may not have been introduced to automatic page numbering, one of the biggest time-saving features in the program. InDesign allows you to set up the page numbering feature in your Master Pages. Then, as you add or shuffle pages, InDesign updates individual page numbers accordingly. You can style the page number any way you like.
Hi Scott, I had a question regarding the sequential numbering Apex example…I am looking to automatically restart the sequence every month, which is not a problem using your example (i.e. changing the year to month in the expression). However, I would also like to add in a condition for year, so that the sequence restarts for each month of each year (i.e. my problem is for example that Feb 2011 last sequence number is 5, and then in Feb 2012 this becomes 6, where I would like it to be 1). I am wondering what the syntax would be. Thanks in advance, Lawn.

Instead of working harder than you need to, insert a one-column table with as many rows as necessary to accommodate your list. Then, using Word's numbering feature, number that column. Finally, convert the table to text. The resulting list is a fixed numbered list, so you'll have to live with its limitations; when you can do so, this method definitely beats most alternative solutions.
×