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

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.
* The solution assumes that there is only one stack to cut, but really there could be dozens of stacks. Take a run of the numbers 1-10000 for example. Let’s say you get 4-up on a sheet and the biggest stack that will fit in the guillotine is 500 sheets. A true cut and stack solution will print on the first stack 1-500, 501-1000, 1001-1500, 1501-2000. Ideal because the numbers can be guillotined and placed back onto a pallet for its next process. It also means I can provide these numbers first to the client and then they can wait for the other numbers (in case they had run out of stock and were in a hurry for replenishment stock). The solution doesn’t do that – instead, the first 500 stack will have the numbers 1-500, 2501-3000, 5001-5500, 7501-8000. That means not only is placement back onto the pallet confusing, but the customer has to wait for the artwork to be completely printed before even getting the first half of numbers. True, I could run the script several times to get the appropriate stacks, but why should I if the script did what I wanted? Especially if there are hundreds of stacks to print?
Is there a way to have page numbering span multiple worksheets in a file? I would like to be able to print all the worksheets in a file and have the page numbers in the second worksheet pick up where the page numbers in the first worksheet ended without having to manually adjust the start point in worksheet 2. Please response back to the group. Thanks. JWeinberg I assume the page numbers are set up in your header/footer. If this is correct then all you need to do is select all the sheets you want to print by clicking on each sheet tab while holding down the control key. This will the...
i have gone through the intersting discussions on this site. I am having a problem with foot notes in Adobe in design cs 4. when i pasted a fresh set of pages in a doc in- in design, the fn numbering starts from 1 all over again in the fresh set of pages. i am not able to insert foot notes manually, as it does not creat the space below the text. I am stuck for help
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!
Gift certificates and promotional coupons can play an important role in your marketing strategy by drawing new and repeat customers to your business. However, how can you tell if they are really working to help you develop your business? To make the most of your time and your marketing budget, you need to track the success of your marketing efforts so that you can determine what marketing tactics are effective for which customers.
Note that we can consider multiple sequences at the same time by using different variables; e.g. {\displaystyle (b_{n})_{n\in \mathbb {N} }} could be a different sequence than {\displaystyle (a_{n})_{n\in \mathbb {N} }} . We can even consider a sequence of sequences: {\displaystyle ((a_{m,n})_{n\in \mathbb {N} })_{m\in \mathbb {N} }} denotes a sequence whose mth term is the sequence {\displaystyle (a_{m,n})_{n\in \mathbb {N} }} .
To recap, you use a DMax function to return the highest number in the Sequence and increment it by 1. You assign the incremented number to a control on your form and then immediately save the record. If your identifier includes additional information from the record, you use an expression that concatenates that information with the sequence number to display the full identifier.
GREAT tip with lots of uses! Thank you. This will save me hours of work on some tickets I’m designing. However, I also need to set up table tents that have numbers on them. They’re 2-up, and are folded, so each number needs to appear twice on the same page. In short, I want a page with 1/1 and 2/2, and I’m getting 1/2 and 3/4. Am I missing an obvious fix? Thank you.
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.

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?
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. :-)

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.


Standard sizes for NCR forms are half page (5.5″ x 8.5″), full page (8.5″ x 11″) and legal (8.5″ x 14″) although custom sizes can be ordered to meet your specific need. The design orientation can be either vertical or horizontal. The link below gives you access to design templates that can be used to lay out your form in the appropriate size and orientation.

I have done this twice now, getting flustered. The ticket part the person keeps has the correct sequential number on it, but the side that we keep has the same number on it for the whole page. What part am I missing, at first I did not uncheck the box, but this time I did but have the same number on the stub side that we keep with the person’s name, etc
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.

Hello! I would like to chart varying salaries against specific Low, middle and high numbers. Any suggestions on how to show this? Example: Salary 1 10000 Salary 2 12000 Salary 3 16000 Low 9000 Mid 15000 High 19000 THANK YOU! Do you want the Low-Mid-High values to be like a benchmark to measure salaries against? You could put horizontal lines across your chart, and use markers for the salary data. Here' a few ways to get your lines: http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials...


One solution is to format the heading with the style and follow it with a hidden paragraph mark. You should format the text in the next paragraph with a style that is not included in the Table of Contents. A hidden paragraph mark keeps the text together on one line when it is printed, even though it is actually two separate paragraphs. The Table of Contents command picks up only those paragraphs with heading styles and places them into the Table of Contents.
Defined lists are often used to track paragraphs for numbering purposes. When you create a paragraph style for numbering, you can assign the style to a defined list, and paragraphs are numbered in that style according to where they appear in the defined list. The first paragraph to appear is given number 1 (“Table 1”), for example, and the next paragraph is given number 2 (“Table 2”), even if it appears several pages later. Because both paragraphs belong to the same defined list, they can be numbered consecutively no matter how far apart they are in the document or book.
A quick way to create a bulleted or numbered list is to type the list, select it, and then click the Bulleted List or Numbered List button in the Control panel. These buttons let you turn the list on or off and switch between bullets and numbers. You can also make bullets and numbering part of a paragraph style and construct lists by assigning styles to paragraphs.

Hi – are you creating your own tickets using the instructions on this page? If so, you can of course change the font and everything else in your Word document. If you are using the Raffle Ticket Creator app (app.raffleticketcreator.com) then you can’t change the font size … you’ll just need to tinker with the exact words that you are including in order to get them to fit on the page. Hope that helps!


I use a template for all my drawings that includes a page number in the lower right hand corner (usually says "Page 1 of 4" for example). I usually edit this number manually, which is fine for documents with a small amount of pages, but if I'm working on a large document (50+ pages) and need to re-order some pages it means editing the page number on every page manually.
I know that PrintShopMail will do it, but I was wandering if there was a less expensive solution out there so that I could get numbered tickets (usually 4-up) right off the Xerox. I just want to avoid having to go the the Windmill after trimming and doing it the old fashion way. There is a tiny little copy shop here in town that is doing it, and am willing to bet that they are not using PrintShopMail, but I'm also not going to ask them to share their methods with a competitor. There has to be cheaper solution. I know that I can do it with auto page numbering in Indesign, but that means I can only print raffle tickets 1-up which wont work.
The Wine project formerly used a date versioning scheme, which uses the year followed by the month followed by the day of the release; for example, “Wine 20040505”. Ubuntu Linux uses a similar versioning scheme—Ubuntu 11.10, for example, was released October 2011. Some video games also use date as versioning, for example the arcade game Street Fighter EX. At startup it displays the version number as a date plus a region code, for example 961219 ASIA.
How do I set up the basic template for text numbering in Word 2008 for the Mac? Here is what is driving me nuts: I want to generate numbered lists - lots and lots of them. The first level numbered lines will have second level under them in many cases, also numbered and indented below the first level. The second level will also have third level under them, intended some more and also numbered. This "sort-of" works fine. It USED to work excellently. Here is what I do. I click the Numbering button in the Bullets and Numbering palette. The line indents and a 1) is aut...

My quick process involves setting up a row of plaques with a01, a02, a03, thru a09. Then copy the plaques to the clipboard. Run the REPLACE TEXT feature to replace "a" with "1". Move row down and paste clipboard back into page. Run REPLACE TEXT to replace "a" with "2". Repeat until I get all the numbers. It's faster than manually typing the numbers in but I know there's go to be someway of automating the process.
I’d like to use my own styles for headings in my Word document. Let’s say- style hdn1 instead of Heading1, and hdn2 instead of Heading2. I know how to create new multilevel list for heading numbers, linking levels to my own styles hdn1, hdn2…. (By the way- why multilevel lists are not accessible for styles formatting through Modify-Format-Numbering like it was in Word2003?)
You want to do this because your document is long and readers can’t easily find the tables/figures they want as numbers like Table 34 are meaningless unless you find the table captions before/after ‘Table 34’. By changing the numbering sequence to include the chapter numbers, your readers will have guideposts to aid their search — if they are in Section 5, they will know that Table 3.2 is back in Section 3 and is the second table in that section.

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.


It's also possible to consecutively number list items in InDesign. Create a text frame for your list and click the numbered list button to insert a list. Type your list items, pressing your "Enter" key between items. InDesign consecutively numbers the list automatically; you can change the number it begins with and the style of the numerals. Press your "Alt" key (Windows) or "Option" key (Mac OS) while clicking on the numbered list button to open a dialog where you can modify those options.
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.
Hi, is there any limit on the number of E-Mails ? I created an archive of 270000 E-Mails (IMAP) and it caused trouble. Can I have that amount in a local folder ? Are there any recommended number ? It locked that 50000 starts being a problem on IMAP already. How else would you handle an archive that you need frequently ? Thanks for your help Stephan If it were me... exporting them(selectively) to user created properly named Windows Explorer blank folders on the hard drive and backing up to a different drive(internal/external/cd/dvd) outside of Windows Live Mail woul...
This chapter (web page) takes you through how numbering is supposed to work in Word and the various controls. It is useful, but primarily on SEQ fields and simple numbered lists and also as reference showing the menus, dialogs and controls and going through the concepts for outline numbering. To actually set up outline numbering that works, refer to the Kelly and McGhie articles.
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.
LION also carries a heavy-duty, 6 wheel automatic numbering machine with rubber faced wheels. The rubber wheels work great for metal marking and plastic marking when used with LION fast dry ink. As with the other LION numbering machines, this machine is made in Japan with precision crafted one-piece hardened steel frame with all metal interior construction. LION machines will provide years of reliable use. Ideal for sequential numbering operations to use as a date and number stamp, serial number stamp, an inspection stamp and etc. sequential numbering in publisher
×