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.
Remember that you must update the values in the sheet if you want to continue the numbering series with the next batch of tickets. For instance, if you want your next batch of tickets to start with 112, you'd open the workbook and change the value 100 to 112, and update the remaining values accordingly. Don't forget to save the workbook after updating the values.
Budget is our income and sometimes this is positive. I need to make this column in a query all negitive values. I am using the IIf function but it is not working. Budget: [budget_amount] IIf ([budget_amount] >=0, [budget_amount]*-1, [budget_amount]) or is there another function I could use? On Mon, 29 Oct 2007 19:18:00 -0700, Tamm Fox wrote: > Budget is our income and sometimes this is positive. I need to make this > column in a query all negitive values. > > I am using the IIf function but it is not working. > > Budget: [budget_amount] IIf ([budget_amount] &g...
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.
You will occasionally want to place an unnumbered paragraph in the middle of a sequence, but the moment you hit Enter, another paragraph number pops up. To fix this, toggle paragraph numbering off by pressing the paragraph numbering button you used for the previous paragraph. (If you use the button’s drop-down, choose None as the numbering scheme.) Unfortunately, the paragraph settings won’t revert to Normal here; it’ll usually have the paragraph indented 0.25. Use the keyboard shortcut CTRL+Q to strip paragraph settings out, then revise the formatting as you wish.

When you’ve finished typesetting your book, you’ll create an appropriate page or pages in the back matter for your endnotes. When you have a spot ready to go, find your endnotes text frame (it might still be on the pasteboard of page 2 or 4), and cut-and-paste it to the appropriate page in your back matter. Note that the endnotes text frame can be copied- or cut-and-pasted without losing any live links. Isn’t technology grand?
John, Sorry for the delay, but I was away last week with limited Internet access. I assumed if you had a Save button, you would know how to put code behind it. To see the code behind a button, Select the button in Form Design Mode and open the Properties Dialog (Right click and select properties), on the Events tab there should be something in the On Click event of the button. If you click the Ellipses […] next to the event, it will open Code Builder where you can enter the code.
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.

An easier way is to setup the table in Excel and use the Excel features to create sequential numbering. The cells making up the whole table can then be selected and copied into a Word document using CTRL/C and CTRL/V which will create a table in Word. Column widths and borders can be set up in Excel and cells can be filled in before copying to the Word document.


One of the best ways to prevent invoice numbering errors is by running a monitoring tool that constantly checks for duplicates and so helps you catch errors before their invoices are finalized. If you use the sequencing system provided by your accounting software, the issue of duplicate or missing invoice numbers is avoided entirely – if not, and an error does occur, your software should have a tool to help you locate and solve it.
Using the instructions in #5, add an incrementing SEQ field. You can highlight any of them, except the reset field. For step 7, enter n}. n is the default switch that inserts the next number in the sequence, making it easy to remember. You don't have to specify the \n switch, because it's the default, but you can add it if it helps document your choice.
A quick search at the top using the term “document numbering” shows 46 different threads, with very good advice, for the most part.  I would first recommend you perform the same search and see what advice may be gleaned from those far older and wiser than myself.  In order to directly answer your question, I would refer you to the following discussion thread.  Many talk about the physical numbering system to use, which is important, and many discuss the frustration that a new person to the position feels when they inherit a mess from someone else and wish to clean it up. 
Is there a way to auto number files with the file number (less .jpeg) and save without having to let my computer grind to a halt, as it does using Automate, contact sheet. The objective is to create a preview set for distribution to clients with the file number annotated at bottom centre. Also, is there any way of creating the text/font/colour/stroke of my choice?

The last option that we’ll present for assigning invoice numbers is according to project number. This is most useful for companies that take on projects where that number is the most important reference for the work. These invoice numbers will include the project number, customer number, and sequence number, with the sequence number at the end. An invoice numbering system organized by project could either begin with the customer number:

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 »
Remember that you must update the values in the sheet if you want to continue the numbering series with the next batch of tickets. For instance, if you want your next batch of tickets to start with 112, you'd open the workbook and change the value 100 to 112, and update the remaining values accordingly. Don't forget to save the workbook after updating the values.
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.
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!

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