Apple Numbers '08 - Manual (Page 145)

Chapter 7 Working with Text 145
m Click outside the hyperlink text, and use the arrow keys to move the insertion point
into the text.
Inserting Page Numbers and Other Changeable Values
You can insert such values as page numbers, page count, and date and time in a
spreadsheet by using formatted text fields, which are automatically updated by
Numbers when they change. Although values such as these are common in headers
and footers (see “Using Headers and Footers” on page 41), you can insert formatted
text fields anywhere in your spreadsheet.
Here are ways to insert formatted text fields:
m To add page numbers, place the insertion point where you want the page number to
appear, and then choose Insert > Page Number.
To change the page number format, Control-click a page number and choose a new
number format.
m To add the total page count, place the insertion point where you want the page count
to appear, and then choose Insert > Page Count.
To include the total page count with each page number, such as “2 of 10,” add a page
number, type “of,” and then choose Insert > Page Count.
To change the page count format, Control-click a page count and choose a new
number format.
m To add and format the date and/or time, place the insertion point where you want the
value to appear, and then choose Insert > Date & Time.
To change the date and time format, Control-click the date and time value, choose Edit
Date & Time, and then choose a date and time format from the pop-up menu. If you
want the spreadsheet to always show the current date and time, select “Automatically
update on open.”
Automatically Substituting Text
Numbers can be set to recognize and replace text you don’t want with text you do
want. For example, when you type “teh,” Numbers can automatically change it to “the.”
To set up automatic text substitution:
1 Choose Numbers > Preferences.
2 Click Auto-Correction and make settings as desired.
To automatically convert single and double quotation marks to smart quotes so that
opening and closing quotation marks are not identical, select “Use smart quotes.”
To make sure that the first word in a sentence begins with a capital letter, select “Fix
capitalization.”