Corel wordperfect office 2002 ユーザーズマニュアル
To rotate text
1 Click a cell with text to rotate.
2 Click Format } Selection properties.
3 Click the Alignment tab.
4 In the Orientation area, enable one of the following options:
2 Click Format } Selection properties.
3 Click the Alignment tab.
4 In the Orientation area, enable one of the following options:
Horizontal — orients text horizontally
Vertical — orients text vertically
Rotated — rotates text to the degree you specify
If you enable the Rotated option, specifying 90 or -90 rotates the text vertically.
Working with numeric formats
Quattro Pro uses two types of numeric formats: number formats and date/time formats. Numeric
formats do not change cell values; they change only the way values display.
When you type numbers, Quattro Pro by default rounds off fractional numbers as necessary to fit
When you type numbers, Quattro Pro by default rounds off fractional numbers as necessary to fit
in the cell. You can change the numeric format of a cell to accommodate, for example, scientific,
currency, decimal, and percent formats.
Quattro Pro lets you hide all values that equal zero on a spreadsheet. Hiding zeros does not
Quattro Pro lets you hide all values that equal zero on a spreadsheet. Hiding zeros does not
remove zero values from the sheet, rather zeros remain in memory and will display if you choose
to unhide them. It is easy to accidentally overwrite cells containing formulas that evaluate to
zero. To prevent this, make sure you are able to undo actions or consider protecting the
spreadsheet.
Quattro Pro lets you format dates and times in a spreadsheet. For example, by default, Quattro
Quattro Pro lets you format dates and times in a spreadsheet. For example, by default, Quattro
Pro displays times in long form as HH:MM:SS (for example, 09:32:30), or in short form as HH:MM
(for example, 09:32) when no seconds are specified, but you can change this format.
To change the numeric format of a cell
1 Select a cell.
2 Click Format } Selection properties.
3 Click the Numeric format tab.
4 Choose one of the following formats from the Numeric formats list:
2 Click Format } Selection properties.
3 Click the Numeric format tab.
4 Choose one of the following formats from the Numeric formats list:
General — to display numbers exactly as you type them (unless the column width is too
narrow)
Number — to choose a negative number and number of decimal places formats, and
separate thousands with commas.
Currency — to choose a country whose currency symbol you want to use
Scientific — to display numbers as scientific notations
Fraction — to choose a fraction format
Hidden — to prevent a cell from displaying its contents
Percent — to display numbers in a percent format
Custom — to choose a customized format
208
Quattro Pro 10