Apple Numbers '09 - Manual (Page 189)

Chapter 8 Working with Text 189
Here are ways to insert formatted text fields:
To add page numbers, place the insertion point where you want the page number to
m
appear, and then choose Insert > Page Number.
To change the page number format, Control-click a page number and choose a new
number format.
To add the total page count, place the insertion point where you want the page count
m
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.
To add and format the date and time, place the insertion point where you want the
m
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.”
To add the spreadsheet’s filename, place the insertion point where you want the
m
filename to appear, and then choose Insert > Filename.
To display the file directory path, double-click the filename and select “Show
directory path.”
To display the file extension, double-click the filename and select “Always show
filename extension.”
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 specify 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.”
To automatically convert the letters in “1st,” “2nd,” “3rd,” and so on into superscripts,
select “Superscript numerical suffixes.”