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.
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.
Awhile back, there was an add-on for excel that had a lot more tools. It showed on the toolbar. Somehow I lost it and I would like to get it back. It had a lot of tools like for changing case and fill ins. Any help wouyld be great. Maybe ASAP Utilities. Try a 'net search for this add-in. Gord Dibben MS Excel MVP On Sun, 22 Mar 2009 20:22:43 -0400, "kmkx70a" wrote: >Awhile back, there was an add-on for excel that had a lot more tools. It >showed on the toolbar. Somehow I lost it and I would like to get it back. It >had a lot of t...
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.
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.
you'd need to use a before save macro. Something like the macro at the end - but it would run on every save, which may not be what you want. I use a macro that gets the invoice # and saves (it does several things). I added a button to the ribbon that calls a macro that runs several macros: Sub FinalizeInvoice() CreateInvoiceNumber CopyToExcel FinalCleanup ' this does the save End Sub This is an automated macro - but it will run every time the file is saved. Private WithEvents App As Word.Application Private Sub Document_Open() Set App = Word.Application… Read more »
It's easy to enter a SEQ field manually. Begin by pressing [Ctrl]+[F9]. When Word displays the blank field, enter seq list1, as shown in Figure A. List1 is a required argument; you can use any descriptive name you like as long as it begins with an alpha character. The parentheses distinguish the numbers within the text. They're not part of the field code. Highlight the field code and press [F9] to display the field's value. As you can see in Figure B, the first field returns (1).
Other notations can be useful for sequences whose pattern cannot be easily guessed, or for sequences that do not have a pattern such as the digits of π. One such notation is to write down a general formula for computing the nth term as a function of n, enclose it in parentheses, and include a subscript indicating the range of values that n can take. For example, in this notation the sequence of even numbers could be written as {\displaystyle (2n)_{n\in \mathbb {N} }} . The sequence of squares could be written as {\displaystyle (n^{2})_{n\in \mathbb {N} }} . The variable n is called an index, and the set of values that it can take is called the index set.
(function(){"use strict";function u(e){return"function"==typeof e||"object"==typeof e&&null!==e}function s(e){return"function"==typeof e}function a(e){X=e}function l(e){G=e}function c(){return function(){r.nextTick(p)}}function f(){var e=0,n=new ne(p),t=document.createTextNode("");return n.observe(t,{characterData:!0}),function(){t.data=e=++e%2}}function d(){var e=new MessageChannel;return e.port1.onmessage=p,function(){e.port2.postMessage(0)}}function h(){return function(){setTimeout(p,1)}}function p(){for(var e=0;et.length)&&(n=t.length),n-=e.length;var r=t.indexOf(e,n);return-1!==r&&r===n}),String.prototype.startsWith||(String.prototype.startsWith=function(e,n){return n=n||0,this.substr(n,e.length)===e}),String.prototype.trim||(String.prototype.trim=function(){return this.replace(/^[\s\uFEFF\xA0]+|[\s\uFEFF\xA0]+$/g,"")}),String.prototype.includes||(String.prototype.includes=function(e,n){"use strict";return"number"!=typeof n&&(n=0),!(n+e.length>this.length)&&-1!==this.indexOf(e,n)})},"./shared/require-global.js":function(e,n,t){e.exports=t("./shared/require-shim.js")},"./shared/require-shim.js":function(e,n,t){var r=t("./shared/errors.js"),i=(this.window,!1),o=null,u=null,s=new Promise(function(e,n){o=e,u=n}),a=function(e){if(!a.hasModule(e)){var n=new Error('Cannot find module "'+e+'"');throw n.code="MODULE_NOT_FOUND",n}return t("./"+e+".js")};a.loadChunk=function(e){return s.then(function(){return"main"==e?t.e("main").then(function(e){t("./main.js")}.bind(null,t))["catch"](t.oe):"dev"==e?Promise.all([t.e("main"),t.e("dev")]).then(function(e){t("./shared/dev.js")}.bind(null,t))["catch"](t.oe):"internal"==e?Promise.all([t.e("main"),t.e("internal"),t.e("qtext2"),t.e("dev")]).then(function(e){t("./internal.js")}.bind(null,t))["catch"](t.oe):"ads_manager"==e?Promise.all([t.e("main"),t.e("ads_manager")]).then(function(e){undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined}.bind(null,t))["catch"](t.oe):"publisher_dashboard"==e?t.e("publisher_dashboard").then(function(e){undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined}.bind(null,t))["catch"](t.oe):"content_widgets"==e?Promise.all([t.e("main"),t.e("content_widgets")]).then(function(e){t("./content_widgets.iframe.js")}.bind(null,t))["catch"](t.oe):void 0})},a.whenReady=function(e,n){Promise.all(window.webpackChunks.map(function(e){return a.loadChunk(e)})).then(function(){n()})},a.installPageProperties=function(e,n){window.Q.settings=e,window.Q.gating=n,i=!0,o()},a.assertPagePropertiesInstalled=function(){i||(u(),r.logJsError("installPageProperties","The install page properties promise was rejected in require-shim."))},a.prefetchAll=function(){t("./settings.js");Promise.all([t.e("main"),t.e("qtext2")]).then(function(){}.bind(null,t))["catch"](t.oe)},a.hasModule=function(e){return!!window.NODE_JS||t.m.hasOwnProperty("./"+e+".js")},a.execAll=function(){var e=Object.keys(t.m);try{for(var n=0;n=c?n():document.fonts.load(l(o,'"'+o.family+'"'),s).then(function(n){1<=n.length?e():setTimeout(t,25)},function(){n()})}t()});var w=new Promise(function(e,n){a=setTimeout(n,c)});Promise.race([w,m]).then(function(){clearTimeout(a),e(o)},function(){n(o)})}else t(function(){function t(){var n;(n=-1!=y&&-1!=g||-1!=y&&-1!=v||-1!=g&&-1!=v)&&((n=y!=g&&y!=v&&g!=v)||(null===f&&(n=/AppleWebKit\/([0-9]+)(?:\.([0-9]+))/.exec(window.navigator.userAgent),f=!!n&&(536>parseInt(n[1],10)||536===parseInt(n[1],10)&&11>=parseInt(n[2],10))),n=f&&(y==b&&g==b&&v==b||y==x&&g==x&&v==x||y==j&&g==j&&v==j)),n=!n),n&&(null!==_.parentNode&&_.parentNode.removeChild(_),clearTimeout(a),e(o))}function d(){if((new Date).getTime()-h>=c)null!==_.parentNode&&_.parentNode.removeChild(_),n(o);else{var e=document.hidden;!0!==e&&void 0!==e||(y=p.a.offsetWidth,g=m.a.offsetWidth,v=w.a.offsetWidth,t()),a=setTimeout(d,50)}}var p=new r(s),m=new r(s),w=new r(s),y=-1,g=-1,v=-1,b=-1,x=-1,j=-1,_=document.createElement("div");_.dir="ltr",i(p,l(o,"sans-serif")),i(m,l(o,"serif")),i(w,l(o,"monospace")),_.appendChild(p.a),_.appendChild(m.a),_.appendChild(w.a),document.body.appendChild(_),b=p.a.offsetWidth,x=m.a.offsetWidth,j=w.a.offsetWidth,d(),u(p,function(e){y=e,t()}),i(p,l(o,'"'+o.family+'",sans-serif')),u(m,function(e){g=e,t()}),i(m,l(o,'"'+o.family+'",serif')),u(w,function(e){v=e,t()}),i(w,l(o,'"'+o.family+'",monospace'))})})},void 0!==e?e.exports=s:(window.FontFaceObserver=s,window.FontFaceObserver.prototype.load=s.prototype.load)}()},"./third_party/tracekit.js":function(e,n){/** ## Hello, can anyone help me with making serial numbers in this way: When I purchase 10 chairs, I want to monitor all of it by having serial numbers each of those 10 and those 10 numbers should have the prefix “CHR-” if they are chairs. “TBL” if tables, the codes are associated with the item category. BTW, items have categories predefined by beforehand on the items by relationships. So when I will want to monitor these 10 chairs, I will only have to click the “generate control numbers” button and each of those purchased items get their own control numbers. I’ve been searching for the best way to create auto numbering for discovery requests: dare I say in WordPerfect I had the most amazing macros that used “counter” and creating a set of discovery was a snap. I’ve struggled to find something workable in Word. Some people use Discovery Request No. X – Interrogatory; others use Interrogatories No. X, Requests for Production No. X, Requests for Admission No. X throughout a set of discovery. There has to be a way to do this in Word, and I’ve tried several different approaches, none of which worked out that well. Would you please steer me in the right direction? Thanks very, very much. Word's Numbering Explained by John McGhie, MVP - comprehensive and not pretty (Downloadable pdf file in letter size) - Reading this is vital to anyone attempting to use automatic numbering or bullets in a law office setting or other places where the documents are likely to be reused or heavily edited. See also How to Create a Template with a downloadable template with style-based numbering. I strongly recommend that you read both of these before doing anything with the contents of this chapter. I'm using Column A of a spreadsheet to number some items in Column B. I've been using Excel's automatic series-filling function, where you drag down from the lower right corner of a cell. However, since some of the rows in Column B are empty, and I don't want them numbered, I have to stop numbering and manually "jump" over the blanks in Column A. Is there a way to automatically number down in Column A, while skipping over the blanks and continuing where I left off? I.e. 1 2 3 4 5 ? Thanks much. Try this in A1: =IF(B1<>"",COUNTA($B\$1:B1),"...


To define a sequence by recursion, one needs a rule to construct each element in terms of the ones before it. In addition, enough initial elements must be provided so that all subsequent elements of the sequence can be computed by the rule. The principle of mathematical induction can be used to prove that in this case, there is exactly one sequence that satisfies both the recursion rule and the initial conditions. Induction can also be used to prove properties about a sequence, especially for sequences whose most natural description is recursive.
Klaus Nordby, one of our good-natured Norwegian hecklers, has produced a ray of sunshine in the midst of a deep, dark Scandanavian winter by coming up with a wonderful little trick involving adding sequential numbers inside a paragraph. For example, 1. this is the first clause of this sentence; 2. this is the second; and 3. this is the third. That’s not a big deal to type, of course, but if you had dozens of them and you needed to insert or remove numbering frequently, doing it manually would be a hassle.
A subsequence of a given sequence is a sequence formed from the given sequence by deleting some of the elements without disturbing the relative positions of the remaining elements. For instance, the sequence of positive even integers (2, 4, 6, ...) is a subsequence of the positive integers (1, 2, 3, ...). The positions of some elements change when other elements are deleted. However, the relative positions are preserved.
I removed the required setting on the table level. The form does not give me an error message now, but does not close on its on. I closed it via a command then looked at the Design Projects table to see if the new record, #896, shows up. A new record is there, with all the entered data EXCEPT the very important field of the Project ID. That field is blank.
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!
Angie, have tried your method; however, I encountered what I surmised was a limit on the amount of characters allowed in that “Enter formatting for number” box: for instance, I can only type as far as “Request for Productio” (excluding quotations)- additional text and codes delete and default back to the incomplete phrase “Request for Productio”. Seems to have a default of 26 characters – anything exceeding that is deleted. The phrase “Request for Admission” completes, but am unable to include anything after that phrase of 26 characters. Not sure why that is, but that’s what I run into when I attempt using the multi-list option.
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.

In this scenario we are assuming that there will be no more than 999 documents attached to a case. In Scenario 2 we assumed no more than 9999 inquires during a year. So you need to adjust the number of zeros when formatting Sequence for the anticipated number of records. Of course this can always be changed later. You also don’t need to format the sequence with leading zeros as the Format function does. As shown the expression returns something like: DCASD/CI123-025 for the 25th document in case CI123 for client DCASD. Without leading zeros it would be: DCASD/CI123-25. The advantage to the latter is that you don’t have to anticipate the number of records you might have in the sequence, but I’ve found many users prefer a more uniform number with the leading zeros.
Typically the second option of saving as a CSV file is the one to choose for use with Data Merge. Click the create button to choose a file name and location, make sure that a header has been assigned and click OK. This creates the CSV file that contains the sequential numbers that can then be used in a Data Merge by opening the Data Merge palette, clicking the flyout and clicking Select Data Source…
Starting an auto-numbered paragraph is deceptively simple. See those buttons on the top row of the Paragraph section of the Home tab? The left-most one is for bullets; the next two to its right are for numbering and multi-level numbering, respectively. Simply click the button to toggle the feature on, or click on the drop-down arrow on each button to select a specific style. If you don’t like any of the delivered choices, you can click Define New to set your own.

Thanks for the quick reply, I think I’m a little confused by the Display aspect of this. Artifact ID is a primary key to the table I am working in and I need it to have a unique identifier that other people can search for. The previously adopted naming convention for this ID is that which I mentioned before, Collection Point ID plus a period and then a sequential number restarting at each new Collection Point ID i.e 2-1050.1, 2-1050.2, 2-1060.1 and so on. So I think I actually need to save this in the Artifact ID field. I realize this might be slightly redundant but I’m not sure how the display would work as far as searching for specific Artifact IDs in the future.
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...
###### CK Note: Word 2007 - 2013 interface has an different automatic numbering scheme which I have been told is much less subject to corruption. Microsoft Word 2010 Bible by Herb Tyson, MVP. However numbering is still very imperfect in these later versions. I still recommend following Shauna Kelly's step-by-step instructions (see above) if setting up numbering in a template or in a document likely to be heavily edited. If you start without doing this and end up with "spaghetti numbering," fixing it will be a very large chore!

I need a way for the priority level to automatically adjust when I add or change an item with a new priority level. I might have 6 tasks, each will have a different priority. If I add one and set it to 1, the others need to increment + by one digit. Adding one to the above the highest would see no change in the others. Adding one in the middle would spread the rest apart (e.g. I have a 3, I put a new record and put it at 3, the old 3 becomes 4, and so on (everything below it would increment one digit).
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: