The Data Format page of the Cell Format dialog box lets you control how the values of cells are displayed.
The top part of this page lets you select the format to be used when displaying numeric values, dates or times.
The lower part of the Data Format page lets you add a Prefix such as a $ symbol at the start of each item or a Postfix such as $HK to the end. You can also control how many digits are displayed after the decimal point for numeric values, whether positive values are displayed with a leading + sign and whether negative values are shown in red.
You can make the appearance of a cell change according to the value it contains, useful perhaps if you are using KSpread to keep track of your household expenses and want to highlight any item greater than, say, one thousand dollars.
To do this select the cell(s) then choose from the menu. This will bring up the Relational Cell Attributes dialog box where you can set the font type and color of a cell to change when the value meets one or more conditions. Note that the second and third conditions only apply if the previous condition(s) are not met.
Use -> from the menu to clear any conditional attributes from selected cells.