With this expression we check only for records that are in the same year as the Inquiry date to increment the sequence. Again, the NZ function will automatically restart the sequence with each year. Cleary, though, we cannot generate this number until the InquiryDate has been entered. Is this value is a user entry, then you may want to check that it’s filled in before generating the number. Something like:
NCR booklets for receipt forms and invoice forms are very handy as a copy of the form can be easily torn from the booklet and given to the customer, while leaving a copy in the booklet for the business. Pages are perforated for easy removal. A sturdy cover wrap maintains the booklet’s integrity and can be inserted between forms to prevent transfer when completing the form.
Warning  Making even minor changes to an outline numbering scheme won't necessarily change the initial position you've selected in the gallery, but rather may create a new gallery position, overwriting an existing one. Because of this problem, attaching numbering to styles is strongly recommended. This is covered in greater detail later in this chapter and in the chapter on Styles.
Add numbers by inserting the same identifier at another location. Alternatively, copy the first one, select it and press “F9” to update the display. As a third option, you can use the keyboard shortcut “Ctrl-F9” and type “SEQ” and your identifier between the braces that appear. For instance, insert “{SEQ mynum}.” Press “F9” to update the field and enable the number to display.
If you know in advance that you need outline numbering for your paragraphs, you will want to choose the correct format from the Bullets and Numbering dialog box. Applying one of the preset formats to a paragraph or paragraphs that are already bulleted or numbered applies it to the entire list. There is a specific tab for outline numbers — the Outlined Numbered tab.
I have now permanently “baked” the Inline Counter system into my InDesign defaults. With no documents open, I made a “Counter” CharStyle and a “Zero Footnote” ParStyle, with those crucial zero-level type size attributes, and selected them in the Document Footnote Options. I also added a blank space as a prefix and a period and a blank space as a suffix. Then I made a keyboard shortcut (Ctrl-Alt-F) for the Footnote/Counter. So now Inline Counters can be inserted anywhere and anytime with close to zero efforts.
Most European countries use sequential numbering schemes. Spain uses distance-based numbering on its Autovias, but not on its Autopistas. Austria and the Czech Republic use distance-based schemes. A number of European countries (including the Netherlands, Belgium and France) do not number motorway intersections, apparently because one cannot "exit" the motorway there. Countries like Germany and Switzerland have attributed numbers to their exit, but instead of the usual exit symbol, they are given a specific interchange symbol.

I want to a sequential number to fill in automatically each time the form is filled out. Malissa, A simple way would be to use something like this, you could assign it to a button, an open or before print event. Sheets("Sheet1").Range("A1").Value = _ Sheets("Sheet1").Range("A1").Value + 1 For other ways to do this or if this is going to be used in a temple have a look here http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others...
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.
There are a couple of ways you can set up Word 2007/2010 to use SEQ fields for numbering — you can set them up as AutoCorrect entries or as Quick Parts. Both ways work; the method you choose is up to you. This long article describes how to create the SEQ fields and the numbering style in your Normal.dotm template; how to save the SEQ fields as AutoCorrect entries in Word 2007/2010 (and how to use them); and how to save (and use) them as Quick Parts. The most consuming part of this process is settings up the fields and the style; once they’re set up, using them is super easy.
The sequential numbers required for the stationery are typically prepared in a spreadsheet such as Microsoft Excel and then exported as a txt or csv file for use with the Data Merge palette. However, a free script called Indys Number Generator written by Stanislav Antos can create sequential numbers without having to open any spreadsheet software. The script has been available for some time but I feel it is a hidden gem and definitely worth discussing.
While InDesign veterans may assume everyone already knows this, I can assure you I have worked with very sophisticated documents from designers who did not take advantage of this basic feature. A good rule of thumb to keep in mind as you tackle InDesign challenges is this: If it’s repetitious, tedious, or time-consuming, there’s probably a built-in solution right there in the program. You just need to go look for it.
Can anyone tell me what the maximum no. of worksheets is in Excel? Ton From Help...Limited by available memory (default is 3) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS "Ton" wrote in message news:EB5EE739-9250-4D83-AA7C-EE82C02C0AA3@microsoft.com... > Can anyone tell me what the maximum no. of worksheets is in Excel? The maximum number only depends on the amount of memory available. -- Best Regards Leo Heuser Followup to newsgroup only please. "Ton"
An overwhelming majority of companies use designation-based part-numbering systems. A Design Management Procedure, for example, may be numbered as SOP 4.4-1. With the previous revision of the ISO 9001 standard, it meant that this document related to the element 4.4, design management. Well, it does not mean the same with the new ISO 9001 revision, simply because design management clause now has a different number: 7.3. What is the solution? The solution is simple: no part numbers, and no designators!
Auto-Number is a very easy to use software program developed by a printer (35+ years in the industry) to eliminate manual or letterpress numbering. The program will print up to sixteen numbers in any location, increment and duplicate. No Experience Necessary! Any person with basic computer skills is able to master this software within minutes. We’ve included set-up templates for the most common jobs. Use as is or modify them to your specs.

Simply copy the second page of the template by highlighting that page and pressing CTRL + C. Windows shortcut keys Windows Keyboard Shortcuts 101: The Ultimate Guide Windows Keyboard Shortcuts 101: The Ultimate Guide Keyboard shortcuts can save you hours of time. Master the universal Windows keyboard shortcuts, keyboard tricks for specific programs, and a few other tips to speed up your work. Read More are wonderful things. Then create a new blank page by pressing CTRL + Enter. Then paste the copied page using CTRL + V. Create a new blank page, and paste again. Keep doing this until you have the desired number of pages that you will need.


There’s an old Steve Martin joke about how to make a million dollars which starts, “First, get a million dollars…” That’s the key to this trick, too: First, get a bunch of numbers. Here’s a file with 1,197 numbers in it. Now import or paste those numbers into a thread so that the numbers appear in the right place. If you need two matching numbers, just import it twice.
I need a running number from 1001-1200, so after I apply the print merge, it creates 200pgs of the voucher.When I try to save this file, it takes almost half an hour to do so.I think this is due to the heavy file size?In addition, the local print shop knows nothing about print merge and imposition, so I have to prepare the artwork readily in A3 size to print.The imposition creates a 10pgs files.I wanted to save this as PDF to preserve the color, but it turned out to be a nightmare (in daytime) for me that it takes more than2 hours to generate the 10pgs PDF.
Thank you for your reply.  It reassured me that I was on the right path. From having read other Help texts, I guessed that I would have to use good ole mail-merge and set up a numbers list in Excel. Luckily my knowledge of Excel was good enough to know about the drag&drop for sequential immediate numbering. When it came to the crunch, it was this particular type of mail merge which gave me a bit of initial difficulty. Despite my having used it happily and often in Word, for labels in Publisher, it was - not surprisingly - different in certain respects; principally the crucial point of the Print stage, which necessitated finding the option Publications & Paper Settings, and selecting 2 specific parameters, namely (1) Multiple pages per sheet,  (2) Single-sided printing (my default double printing had appeared). Once I'd sussed this, it was plain sailing.  Thanks again.
However, what I want it to do now, instead of just putting the number into the attribute value, I want the number to be a suffix to the existing default tag value of the tag named "ID" which is "ADDRESS:" for some blocks and "ELEVATION:" for other blocks but the tag name that the routine always has to filter for is "ID". That way the user can pick anywhere on the block - not being forced to pick the tag we want to add numbers to.

Thank you for these instructions!! I’m using them to auto number my son’s baseball team raffle tickets which we hand numbered last year (UGH!). I followed the instructions exactly but for some reason the numbering is starting at 2 every time. I did deselect the checkbox about the column headers which seems the obvious culprit. Any ideas? I’m using Word on a PC. Thanks!!
    Numbering raffle tickets can be a rough project to tackle without the right tools. Luckily you can number raffle tickets or any other document or form with a desktop publishing software program you may already own like Microsoft Word, Publisher, Adobe Indesign or CorelDraw or any desktop publishing software that has a mail merge function.  Then all that is needed is a program that can create the mail merge file you need to number your tickets like starting number, ending number, prefix and so on. And for that program we suggest Number-Pro.

Am I the only individual here who is using CS3, and trying the method described, only to find that my version (5.0.2) for the mac doesn’t have the options anywhere that the author suggests? I have spent the past 2 hours trying to find the same screenshots the author has, only to become reall discouraged. Perhaps he is using a windows version that is setup differently?

In answer to your first question, I don’t believe there’s any way to add your own heading names to the list of Chapter heading options in the Caption numbering dialog box. I tried creating a new heading style and setting it to Level 1 (on the Paragraph dialog box), but it didn’t put it into the list. That’s all I could think of that might set it, but it didn’t work.


A3 is the result of A1/21 I want to bracket the number in A4 In MSWorks I would type the statement ="["&string(A3,0)&"]" In excel I get in some cells [1.436871259834] I'd like it to read [1] Help please. -- rodney@touch88gum.com.au (Remove gum to reply) Rodney, ="["&ROUND(A3,0)&"]" -- HTH, Bernie MS Excel MVP "Rodney" wrote in message news:OkME4oGVEHA.2564@TK2MSFTNGP11.phx.gbl... > A3 is the result of A1/21 > I want to bracket the number in A4 > In MSWorks I would type th...
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. A Current Page Number marker must be set on pages in order to use this feature. The Current Page Number is a special character inserted in a text frame on a page or master page (recommended) where the page number will appear, by selecting Type>Insert Special Character>Markers>Current Page Number.
If you need to apply numbering within a paragraph rather than to the entire paragraph, you use Word's ListNum feature. Using the ListNum feature will allow you to take advantage of the numbering system you're currently using in your document (it will use the one you implemented most recently if you're not currently using a numbering system). The ListNum Field is available in Word 97 and later and interacts with multi-level list numbering (which should be linked to styles as set forth here). Here is a brief explanation of differences between the ListNum field and the Seq field.
Moreover, the subscripts and superscripts could have been left off in the third, fourth, and fifth notations, if the indexing set was understood to be the natural numbers. Note that in the second and third bullets, there is a well-defined sequence {\displaystyle (a_{k})_{k=1}^{\infty }} , but it is not the same as the sequence denoted by the expression.
If you know in advance that you need outline numbering for your paragraphs, you will want to choose the correct format from the Bullets and Numbering dialog box. Applying one of the preset formats to a paragraph or paragraphs that are already bulleted or numbered applies it to the entire list. There is a specific tab for outline numbers — the Outlined Numbered tab.
One of the easiest ways to begin applying numbers is by starting to type a numbered list. Word recognizes that you are creating a list and responds accordingly by converting text that you type into numbered items. The number scheme, delimiter characters that mark the beginning or end of a unit of data and formatting are all based on what you have typed.
This tip was very helpful. Now I have been able to automatically number dozens of examples in a linguistics paper, and as I revise the paper and insert new examples between the existing examples, the numbering is automatically adjusted. Now the next step is how to use bookmarks for the references to the examples in the text of the paper. The references need to point to specific examples, and need to be automatically adjusted when the numbering of examples is adjusted. Any ideas on how to do this?
    Numbering raffle tickets can be a rough project to tackle without the right tools. Luckily you can number raffle tickets or any other document or form with a desktop publishing software program you may already own like Microsoft Word, Publisher, Adobe Indesign or CorelDraw or any desktop publishing software that has a mail merge function.  Then all that is needed is a program that can create the mail merge file you need to number your tickets like starting number, ending number, prefix and so on. And for that program we suggest Number-Pro.
Word includes a special sequencing field that you can use to do all sorts of numbering. You can even use the SEQ field to help create broken numbered lists. (A broken numbered list is one in which the flow of the list is interrupted by paragraphs of a different format.) This approach to creating numbered lists is particularly helpful and much less prone to the problems inherent in Word's built-in list numbering. For the purposes of this tip, the format of the sequence field is as follows:
Another fan of Fusion Pro Desktop here. This is exactly what you need. We have sold both PrintShop Mail and Fusion Pro Desktop for this very application (numbering) and other VDP applications. Fusion Pro Desktop easily beats PrintShop Mail from both a price and performance viewpoint. You could also try Printer's Bench http://www.elkriversystems.com/ProductsList.aspx for a good entry level package
One of the easiest ways to begin applying numbers is by starting to type a numbered list. Word recognizes that you are creating a list and responds accordingly by converting text that you type into numbered items. The number scheme, delimiter characters that mark the beginning or end of a unit of data and formatting are all based on what you have typed.
As you can see, the sequence name can be most anything (e.g. mySeq, A, B, or Bob's_your_uncle). If you start a sequence with a new sequence name the numbering restarts with 1. Look at Mary's first chore in the right hand column. Here you see the reset switch \r1 was used. This switch directs Word to restart the sequence named "A" with "1" at this point.

If you use the Form Wizard, controls will be named with the field name the control is bound to. But that name can be changed. This trips up a lot of people because my code samples use a naming convention that is not what is automatically generated. So you just need to make sure you use the correct name for the object. The name is shown in the Name property on the Other tab (Not the Caption property). To determine what field in your table the control is bound to check the ControlSource property. It should be bound to the PONum field.

Note that the list name remains the same for all of these tags. Table titles have a level 4 designation, and Figure titles have a level 5. The numbering style calls out the level 4 numbers (^4) on the Table titles, and the level 5 numbers (^5) for the Figure titles. It’s important to note that for this style, both of these restart after the level 3s (Subhead 2s).


Thank you for your prompt response, Deborah. However, I don’t believe I explained myself in the detail required. To reiterate: My autonumbering example is FORM INTERROGATORY NO. 1.1. The next interrogatory would be numbered 1.2, then 1.3, etc.–automatically and sequentially numbered. Next would be FORM INTERROGATORY NO. 2.1 (see example 1.1 above). Please understand that the interrogatory must be auto-numbered–both the 1 and the 1, both the 1 and the 2, etc.; both the 2 and the 1, both the 2 and the 2; both the 3 and the 1; both the 3 and the 2. That is my dilemma.
Some freeways' exit number starts from a advanced number (i.e. higher than 1). Some reason of starting a number higher than 1 is due to the expectation that the highway will extend on both ends. For example, Ontario Highway 400 starts at 20 because it was expected that the south end of the highway would extend to downtown Toronto (which was never built). Another reason to use a higher number is that the freeway is branching off from another freeway. An example is British Columbia Highway 5, which branches off British Columbia Highway 1 and starts at 170.
×