Author, trainer, and learning and development expert David Rivers has over 20 years experience helping government, hi-tech, and healthcare businesses increase their efficiency and productivity by integrating technology tools. With deep experience in Microsoft Office, elearning tools, and assorted productivity tools such as FrameMaker and RoboHelp, David is passionate about helping people improve their workflows to recover time in their schedules. His clients include Microsoft, Corel Corporation, Halogen Software, and the City of Ottawa. David is also a published book author on topics ranging from Photoshop to Acrobat and the Microsoft Digital Image Suite.

Thanks very much for your prompt reply, which reassured me that I was on the right path. From having read various Help topics, I suspected that I'd have to use an Excel data source for the numbers. Fortunately, my knowledge of Excel was good enough to know about the drag and drop facility to create automatic sequential numbering, so the data source creation was easy. In the end, it was the mail merge (no surprises?) which proved a tad tricky, but I got there in the end. I've used MM many times and quite happily in Word documents, but for Publisher label format, it was of course a bit different. The important bit that I had to discover for myself was the significance of, after getting to the Print stage, going into Print options, to Publication & Paper Settings, and selecting Multiple Pages per Sheet (& in my case, also "Single-sided" cos my default of duplex printing had come up). But TA-DA!  All is fine now. Thanks very much again.
Hi everybody. I am having a problem with a query that I am working on. I have a table containing customer names, trade dates, and dollar amounts. Customers can have multiple trades on the same day, sometimes even the same dollar amount. I want to have the table sorted by name, date, then dollars so the query pulls everything in from lowest/earliest to highest/latest. I was trying to make a query that pulled in the customer name and trade dates, then added a new column called "Row" that had the record number. I want the query to show all names and dates, since there are ...

As I indicated, because you want to only generate this number just before saving, I would put this code behind a Save button or another event that runs just before you save the record. So if you want to prevent duplications, you don’t use the expression as a control source, but put the code behind a button or event. Since you have a Save button, put it there.
The process described in this tip works best if you have a single list in your document. Note that the sequence field starts at the beginning of the document and numbers through the whole document, based on the identifier you use. If you are going to have multiple lists in your document, then you can add a second AutoText entry to help with this. The only difference in the above steps is that the SEQ field you define would look like this:
Both the United Kingdom and the Republic of Ireland use sequential numbering systems, with the junction number indicated by a white number in a black square in the corner of signs. In the United Kingdom they are frequently referenced in the media as the number with "J" on front of it, with for example Junction 1 being referred to as "J1". If a junction is newly constructed to between two existing junctions, it is normally allocated the number of the lower of the two junctions, with the letter "A" attached (and so on). For example, a new junction opened between junctions 3 and 4 would become Junction 3A.
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.
All of this happens in the Bullets & Numbering dialog box, shown below. You will definitely want to use paragraph styles for this. My first one is called Chapter title. You will need to begin by changing the List Type to Numbers for all of the levels, and you must both name the List and use the same named list for all Levels. You do this by selecting the List > New List.
A defined list can be interrupted by other paragraphs and lists, and can span different stories and different documents in a book. For example, use defined lists to create a multi-level outline, or to create a running list of numbered table names throughout your document. You can also define lists for separately numbered or bulleted items that are mixed together. For example, in a list of questions and answers, define one list for numbering the questions and another for numbering the answers.
If a sequence converges, then the value it converges to is unique. This value is called the limit of the sequence. The limit of a convergent sequence {\displaystyle (a_{n})} is normally denoted {\displaystyle \lim _{n\to \infty }a_{n}} . If {\displaystyle (a_{n})} is a divergent sequence, then the expression {\displaystyle \lim _{n\to \infty }a_{n}} is meaningless.
As an example of surprising version number ordering implementation behavior, in Debian, leading zeroes are ignored in chunks, so that 5.0005 and 5.5 are considered as equal, and 5.5<5.0006. This can confuse users; string-matching tools may fail to find a given version number; and this can cause subtle bugs in package management if the programmers use string-indexed data structures such as version-number indexed hash tables. Once you are happy with your basic layout, copy everything three times so you have a page of four tickets. At this point, they won't be numbered tickets just yet, you will add the numbers in a moment: Manually, you can obtain what is called a Bates stamper that automatically increases the number on the stamper each time it is stamped on a document. This will assist you in not having to either write the increasing numbers on the document or manually changing a stamper each time you place a number on a document. Hello Bruce, I seem to be having a different problem altogether. I created my ticket in word using logos and text boxes as needed, ticket looks great. I followed your very clear instructions but when I did the Finish & Merge I got this message, "You cannot include DATA, NEXT, NEXTIF, or SKIPIF fields in comments, headers, footers, footnotes or endnotes." I then click on OK and get this, "A field calculation error occurred in record 1. Bruce any help would be much appreciated. Thank you!! In the 21st century, more programmers started to use a formalised version policy, such as the Semantic Versioning policy.[1] The purpose of such policies is to make it easier for other programmers to know when code changes are likely to break things they have written. Such policies are especially important for software libraries and frameworks, but may also be very useful to follow for command-line applications (which may be called from other applications) and indeed any other applications (which may be scripted and/or extended by third parties). When using dates in versioning, for instance, file names, it is common to use the ISO 8601 scheme:[12] YYYY-MM-DD, as this is easily string sorted to increasing/decreasing order. The hyphens are sometimes omitted. ^ Excel has changed its maximum size many times, originally 16,365 rows by 128 columns, while other programs of the era often compared themselves by increasing this - WingZ was 32,768 by 32,768 for instance. Modern spreadsheets have much larger limits, Excel from Office 2010 on are 1,048,576 by 16,384. Duplicating Function. Some programs enable you to press one key in a specific field to duplicate the information contained in the same field in a prior record. For example, if you typed in ABC Purchase Contract in the TYPE field of your prior document record, then, when you are at the TYPE field in a subsequent record, press the appropriate key and the TYPE will be duplicated in the second record automatically. This is used most effectively while objectively coding documents. Often packet headers and file format include a version number – sometimes the same as the version number of the software that wrote it; other times a "protocol version number" independent of the software version number. The code to handle old deprecated protocols and file formats is often seen as cruft. Thank you for these clear instructions. I have had the same problem as Mommy Vaughan and followed the suggestion. However, on re-opening the Word document, I have the dialogue box Invalid Merge Field. I have to use Task Manager to close down Word. I am using Word 2010. Maybe that is part or all of the problem. Any ideas please? I need to sort this by tomorrow night to print them on Monday! If the document control field is auto-generated, the value is not displayed when adding the document. To avoid the possibility that two users might be creating a new document control number at the same time the number is only created and viewed after the document has been added to the library. The original form in pdf format was read and printed by the Adobe Reader to the numberED provided numberED printer - creating a Windows spool file used by numberED as a background page on which the numbers and text were added. numberED then printed the combined numbers and text with background form to a printer in one pass. Some of the output (the last 5 sets of the 1800 sets) is captured here as a pdf file for your viewing convenience. Step 3: Configure Auto numbering – Here you will be presented with “Sequence Name” and “Start Number”. Add your unique value for “Sequence Name” and “Starting number”.  Click “Add” when done.  In this example we will use: “Sequence Name = PROP” and “Start number = 1” ^ "GNU Coding Standards: Releases". GNU Project. 2014-05-13. Retrieved 2014-05-25. You should identify each release with a pair of version numbers, a major version and a minor. We have no objection to using more than two numbers, but it is very unlikely that you really need them. Now for the slightly hard bit. If you just try and complete your merge now, you'll get several pages of tickets. Each page will have four tickets on it. But all tickets on any page will have the same number. Each page will have a different number, but all the tickets on that page will have the same number. That's no good. You need each ticket to have a different number. Apple had their own twist on this habit during the era of the classic Mac OS. Unlike traditional version numbering (where 1.5 is not half-way between 1.0 and 2.0, given there could be any number of minor releases, e.g. 1.22). Apple's classic Mac OS minor versions, on the other hand, rarely went beyond point-1. When they did, they twice jumped straight to point-5, suggesting the release was "more significant". The complete sequence of classic Mac OS versions (not including patches) is: 1.0, 1.1, 2.0, 2.1, 3.0, 3.2 (skipping 3.1), 4.0, 4.1, 5.0, 5.1, 6.0, 7.0, 7.1, 7.5, 7.6, 8.0, 8.1, 8.5 (jumped), 8.6, 9.0, 9.1, 9.2. Thus, "8.5" became its own marketed release to mean "eight and a half", and 8.6 effectively "8.5.1". [otp_overlay] [redirect url='' sec='7']
To enter specific sequential number codes, such as purchase order numbers, you can use the ROW function together with the TEXT function. For example, to start a numbered list by using 000-001, you enter the formula =TEXT(ROW(A1),"000-000") in the first cell of the range that you want to number, and then drag the fill handle to the end of the range.
If you work in a business where you need to sequentially number items, you might be wondering if there is a way you can use Word to create the labels for you. Word has many ways you can implement some type of numbering in your documents. For instance, you can use different fields for numbering, or use numbered lists, the captioning feature, or you can use mail merging. While all of these features (and more) use some type of numbering in them, they are not all well suited to creating labels.
You saved my life! I work at a School Board with 200+ schools and 100+ departments and I have to number every ticket I make. Football, Baseball, Raffles, Prom, Graduation… the list goes on. The worse part is each is different and has to have x number in this color that color it can be very frustrating. Then to top it off I have the most random number of requested tickets sometimes and it was extremely difficult to find a method that worked and yours did! Like a charm! I can choose how many zero how many out I need and if there are special versions I can separate them too! Thank you, I was just about to run screaming from the building!
In Excel, I created a file with columns A-H labeled: ticket 1, stub 1; ticket2, stub2; ticket3, stub3; ticket4, stub4. I then numbered two rows across 1 -4, then 5 -8. Then I dropped down to A – H in row 260. (I did this to give 1,000+ numbered tickets.) I then used the Excel fill function chosing series and told the program to skip by 4. It filled the rows. I then saved as a tab delimited text file.
Hi Jason! Hard to say when I’m not sure which part isn’t working for you. If the numbering isn’t continuing across separate frames, you need to make sure you’re using a list. If they are in the wrong order, remember it uses the paste/creation order to number them. If neither of those fix it, let me know what specific issue you’re having. Good luck!
Word templates are wonderful things. Microsoft, and hundreds of other people, have created some great free templates for almost everything. With these free templates you can make meeting agendas The 15 Best Meeting Agenda Templates for Microsoft Word The 15 Best Meeting Agenda Templates for Microsoft Word These meeting agenda templates for Microsoft Word can get you off to a great start for any type of meeting. Read More , beautiful flowcharts How to Create Stunning Flowcharts With Microsoft Word How to Create Stunning Flowcharts With Microsoft Word Used with imagination, flowcharts can simplify both your work or life. Why not try out a few flowcharts with one of the easiest tools on hand – Microsoft Word. Read More , professional resumes How to Create a Resume Template with Microsoft Word How to Create a Resume Template with Microsoft Word Your resume could be the difference between interviewing for the job of your dreams or never hearing back from the employer — use these tips to make sure it's the best it can be. Read More , and custom calendars 10+ Sites to Find the Perfect Free Printable Calendar Template All Year Long 10+ Sites to Find the Perfect Free Printable Calendar Template All Year Long You can never have enough reminders that your most valuable personal resource is limited. Our selection of printable weekly, monthly, and yearly calendars will help you manage your time wisely. Read More in minutes. A custom calendar might be a good fundraiser, too!
If you want to use a bullet found in a specific font (such as the pointing hand from Dingbats), be sure to set the bullet to remember that font. If you use a basic bullet character, it’s probably best not to remember the font, because most fonts have their own version of that bullet character. Depending on whether you select the Remember Font With Bullet option, a bullet you add can reference either a Unicode value and a specific font family and style, or just a Unicode value.
I have a document where in I have to make two kinds of page numbering, A catalog (individually made) which should always start at page 1, and the other is a compiled version where the pages should be a continuous page. They both have the same content but with different output so I tried using layers, but fail to set the page numbering to auto. because setting them would affect both layers.
That’s enough tips for now. You’ll be filling your fundraising thermometer template How to Create Your Custom Excel Fundraising Thermometer Template How to Create Your Custom Excel Fundraising Thermometer Template Use an Excel thermometer chart to visually keep track of your financial goals. Whether you're saving for a new gadget or fundraising for a good cause, here's a step by step tutorial. Read More in no time. Let’s get to the tickets.
Specifically, 8 to 10 times in my career, I have set up a robust set of MS Word “Auto Text Entries.” Some, short phrases as in this article (e.g. “Interrogatory No. __,” “Long Corporate Name of Client, Inc.,” etc.). Some large blocks of text, paragraphs, or formatting chunks (e.g. Memorandum Start (To:, From:, Date:, Subject: etc.); Caption Block for [Local] Court; Signature Block; Certificate of Service, etc.).
Joshua, I described this problem in my post #5 — the footnote settings are doc-global. I know no present solution to your problem — which is why we still need Adobe to code a counter! And we also need to be able to set up footnotes which are frame-wide, not just column-wide. And, natch, we need headings which are frame-wide, spanning multiple columns — so the ID engineers can’t retire quite yet. :-)
The next step is to create the simple Excel workbook that contains the ticket numbers. Open a blank Excel sheet. Using Figure B as a guide, create the ticket numbering sheet and save it, making sure to note the new workbook's name and location. As we discussed earlier, the Excel workbook stores the ticket numbers. In this example, we'll create 11 tickets numbered 100 through 110. You'll need to update the ticket values for each merge.

Version numbers are used in practical terms by the consumer, or client, to identify or compare their copy of the software product against another copy, such as the newest version released by the developer. For the programmer or company, versioning is often used on a revision-by-revision basis, where individual parts of the software are compared and contrasted with newer or older revisions of those same parts, often in a collaborative version control system.

I am trying to create a macro for outlook 2016 appointments that would add a number sequentially each time the appointment template was opened. I need to run this under public user so as others open it will give next number. Thank you in adance here is form Sequential Number Here Outside Assignment #: Click here to enter text. Court Reporter Needed: Click here to enter text. Job Type: Click here to enter text. Referral: Click here to enter text. Assignment Date: Click here to enter a date. Contact: Click here to enter text. Time: Click here to enter text.… Read more »
Design your ticket, use excel or libre's version and create the numbers. Save those numbers as text, I always make the first one xxx then 001 and so on, xxx will be the master page. Use data merge from Indesign to create the master ticket, you will need to make a text box for the number. Once it looks good to you draw a text box around the whole ticket. At the bottom of the data merge tab is a button that gives you the options how you want your layout, columns or rows, etc. even has a preview. once you click create it will create another file with all your tickets sequentially numbered. It'll be a couple of hours before I'm at work but can post the link I used to create these for the first couple of times.
Step 4: Go to your coupons, page 1. Select the first text box (Command + Shift + Click to release from master page) and paste. The numbers will populate all of the boxes on that page (0001-0008). Now, here's where I'm not sure if I have a plugin doing this or not. The document should add pages to correspond to all of the numbers you have. If it doesn't (and it's doing it on mine because of a plugin), you can select the little red plus in the bottom right text box, add a page and hold down the shift key when pasting into the top left text box of page 2. That will add pages as needed.
Is there a way to code the special interrogatory numbers wherein the identify of documents is requested such that those specific special interrogatories (and only those specific special interrogatories) are automatically generated in a separate demand for production of documents? In other words if Special Interrogatory numbers 3, 6, 9, 12 request identification of documents, is there a way to code those special interrogatories so that within the demand for production of documents, those specific but individual special interrogatory numbers can be referenced?
I haven’t tried this… But according to the Microsoft instructions about field switches (, you can add text to a field code. The text must be in single quote marks, and displays as a constant for the field. The examples on that web page show the text at the end of the field, but you could try it earlier in the field by testing putting ‘120/’ in front of where the SEQ number will go.
Step 2: Create a new doc for your numbers. Using Paragraph/Bullets and Numbering choose Numbering and set the Format to the 4 digits you've indicated in your sample. In the box below Format, remove the ".^t". This will remove the period & tab after the style. With that style set, hit return to create a number. Repeat for as many numbers of coupons you'll have. You can create 10 and copy & paste for however many numbers you need. You could possibly create your numbers in Xcel, but I'm instructing in ID only.

Place the insertion point in the paragraph and choose Restart Numbering from the context menu or choose Type > Bulleted And Numbered Lists > Restart Numbering. In normal lists, this command assigns the number 1 (or letter A) to a paragraph and makes it the first paragraph in a list. In multi-level lists, this command assigns the first lower-level number to a nested paragraph.
I haven’t tried this… But according to the Microsoft instructions about field switches (, you can add text to a field code. The text must be in single quote marks, and displays as a constant for the field. The examples on that web page show the text at the end of the field, but you could try it earlier in the field by testing putting ‘120/’ in front of where the SEQ number will go.
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.
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?
A series is, informally speaking, the sum of the terms of a sequence. That is, it is an expression of the form {\displaystyle \sum _{n=1}^{\infty }a_{n}} or {\displaystyle a_{1}+a_{2}+\cdots } , where {\displaystyle (a_{n})} is a sequence of real or complex numbers. The partial sums of a series are the expressions resulting from replacing the infinity symbol with a finite number, i.e. the Nth partial sum of the series {\displaystyle \sum _{n=1}^{\infty }a_{n}} is the number

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.

Microsoft Publisher, the desktop publishing component of the Professional version of the Office Suite, can perform many time-saving tasks for busy business owners, including layout and design work. It can even help you avoid a shopping run to try to find tickets for your next employee picnic, holiday giveaway or executive board meeting. Create your own tickets, including the vital sequential ordering needed for raffles or attendance tracking, using Publisher’s page numbering. With a few tricky manipulations of the page number process, you can start running the numbers in an entirely new fashion.
Using this script… no. While I use the data merge feature of InDesign often, I avoid the “multiple records” feature, but I typically prepare one record on one page, output the resulting file to PDF and then let the imposing software take care of the page imposition. If page imposition software is something that you don’t have, there is an alternate technique that requires preparing one record on a page, and then using the multipageimporter2.5 script to import them onto a larger sheet. Here is the link to that article:

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...
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.