Numbers - Automatically Substituting Text

background image

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:


Choose Numbers > Preferences.


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

background image

To set Numbers to automatically detect that something you’ve typed is an email
address or a URL, select “Automatically detect email and web addresses.” Email and
web addresses you type automatically become hyperlinks for Mail or Safari.
To use automatic list generation, select “Automatically detect lists.”
To automatically replace misspelled words if there is only one option in the spelling
dictionary, select “Automatically use spell checker suggestions.”
To replace one or more characters with one or more different characters, select
“Symbol and text substitution.” Then use the rows in the table to define and activate
specific substitutions. For example, when you type (c), you can have Numbers
automatically convert it to © by putting a checkmark in the On column. To add a row
to the table to define your own substitution, click the Add (+) button. To remove a
selected item, click the Delete (–) button.

After you specify substitution settings, they’ll apply to any text you change or add in
any Numbers spreadsheet.