Microsoft KB Archive/135775

Mac Works: How to Increment Numbers in Spreadsheet and

PSS ID Number: Q135775 Article last modified on 10-22-1998

2.x 3.x 4.0 4.0a 4.0b

MACINTOSH

=
=========================================================

= SUMMARY =

This article explains how to create columns of incrementing numbers in both the Spreadsheet and the Database portions of Works.

= MORE INFORMATION =

Making an Incremental Number List in the Spreadsheet
To make a column of incremental numbers in the Spreadsheet, do the following:


 * 1) Click cell A1.
 * 2) Type in the number “1” (without the quotation marks), and press RETURN.
 * 3) Click cell A2.
 * 4) Type the formula “=A1+1” (without the quotation marks), and press RETURN.
 * 5) Select cell A2 and extend the highlight to include the cells below cell A2.
 * 6) On the Edit menu, click Fill Down.

This creates a list of numbers starting at 1 and increasing in increments of 1. To change the number where the list starts, change the number entered into cell A1. To change the increment amount, change the formula in cell A2.

Making an Increment Number List in the Works 4.0 Database
NOTE: These instructions apply only to the Works 4.0 Database. To create an incremental number list in versions 2.x and 3.x, follow the instructions in the Making an Increment Number List in the Spreadsheet. Then, paste the spreadsheet information into a new database field.

To increment numbers in the Database, do the following:


 * 1) On the View menu, click List View.
 * 2) On the Insert menu, click Insert Field.
 * 3) In the Type section of the New Field Dialog Box, click Serialized.
 * 4) In the Appearance section, type the prefix, number, and suffix you want.
 * 5) In the Increment By box, change the increment to the value you want to use.
 * 6) Click OK.

A serialized field is created. Lines are added automatically to the serialized field as you enter new records into your database.

For more help on creating serialized fields in a database, see page 224 of the Works 4.0 manual.

KBCategory: kbusage kbhowto KBSubcategory: macworkskb

Additional reference words: kbhowto 2.00 3.00 4.00 4.00a 4.00b 3.00a 2.00a mac m_works mwksdb mwksss ====================================================================== Version : 2.x 3.x 4.0 4.0a 4.0b Platform : MACINTOSH Issue type : kbhowto ============================================================================= Copyright Microsoft Corporation 1998.