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.

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 »
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.
I tossed back a rather glib answer about using the AutoNumLgl field code to number the discovery requests, and she threw in this little wrinkle: her attorneys like to play mix-and-match with their discovery. In other words, they may put in a couple of interrogatories, then throw in a related request for production, then another interrogatory, then a request for admission that’s related to that interrogatory.
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.
Ok I guess it is better for me to explain what I am doing. I am in the process of creating an Access Database that an individual has been using an Excel spreadsheet forever and a day. Well the individual has on occasion doubled up numbers, forgot numbers, etc. So on what I have learned from different Access courses and Google searches I am trying to apply my knowledge.

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.


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.
A best practice that we recommend to our clients is to create a base/folio master –with styled and positioned footers and current page number special characters– on which all other masters are based. This allows a footer that may contain date or issue information to be updated once and the changes are reflected in all of the master pages. If your masters only have current page number special characters then you can just add them to each master and the page numbers will be reflected when each master is applied to your document pages.
Sequential exit numbering usually begins with exit 1 at the beginning of the road; each subsequent exit is given the next number. Letter suffixes are commonly used when new exits are added. For example, on the New York State Thruway, an exit was added between 21 and 22, and was given the number 21A. Subsequently, a new exit was added between 21 and 21A, leading to the sequence 21 - 21B - 21A - 22. In Florida, some new exits got the suffix C, so that if it had or acquired separate exits for the two directions, they would be 15CA and 15CB rather than 15AB. There are also occurrences of this happening on the New Jersey Turnpike; the original interchanges opened in 1951, with newer exits as recently as 1982. On the Baltimore Beltway, there is an exit 12B-C (MD 372), as well as 12A (US 1). There is also an exit 8A (I-895) and an exit 8 (MD 168).

Hello! I already have automatic numbering set up (to change paragraph numbers automatically when paragraphs are moved within a document) but I would also like to have automatic lettering within the same document that is independent from the numbering. Example, paragraph 1 references Exhibit A, paragraph 2 references Exhibit B, so on and so forth. Currently using the above referenced method, the auto numbering lettering then follows as if the letters are a representation of the corresponding number (if that makes sense), ex: 1 B 3 C 5 D. How do I have the number sequencing independent from the letter sequence? Thank you in advance!
×