Creating labels and special characters
You can create labels in a spreadsheet which, unlike other cell data, cannot be calculated in formulas. A label can be text (address), text with numbers (145 Howard Street), or numbers seen as text (202-555-1212, a phone number). A label can begin with any letter, punctuation mark, or symbol, except the following characters:
|
Character
|
Description
|
|---|---|
|
/
|
forward slash
|
|
+
|
plus
|
|
-
|
minus
|
|
$
|
dollar sign
|
|
(
|
opening parenthesis
|
|
@
|
at sign
|
|
#
|
number sign
|
|
.
|
period
|
|
=
|
equals
|
If you type one of these characters, Quattro Pro treats the information as a formula or value. You can force Quattro Pro to read values as labels by typing an alignment character before the value. For example, to enter (Before Taxes), you would type: “(Before Taxes).
You can insert special characters and symbols that are not on your keyboard, such as icons, phonetic characters, and characters in other languages. Quattro Pro also lets you repeat characters or a series of characters in a cell.
These are examples of special characters and symbols.
To create a label |  |
|
1.
|
|
Click a cell.
|
|
2.
|
|
Type alphanumeric characters.
|
|
3.
|
|
Press Enter.
|
To create a label from a value | |
|
To create
|
Do the following
|
|---|---|
|
Left-aligned label
|
Type ‘ before a value.
|
|
Right-aligned label
|
Type ” before a value.
|
|
Centered label
|
Type ^ before a value.
|
|
•
|
|
You can also type an alignment character before a backslash, if you want a label to begin with a backslash, but don’t want to repeat the character after it.
|
To insert special characters and symbols | |
|
1.
|
|
Click a cell.
|
|
2.
|
|
Click Insert
 Symbol. |
|
3.
|
|
Choose a character set from the Set list box.
|
|
4.
|
|
Choose a character from the Symbols list.
|
|
5.
|
|
Click Insert.
|
|
•
|
|
You can also insert special characters and symbols by clicking the WP characters
 button on the property bar. |
To repeat a character | |
|
1.
|
|
Click a cell.
|
|
2.
|
|
Type \ (backslash character), and type a character.
|
|
3.
|
|
Press Enter.
|
To repeat a series of characters in a pattern | |
|
1.
|
|
Click a cell.
|
|
2.
|
|
Type \ (backslash character). and type the set of characters to be repeated.
|
|
For example: \abc.
|