
To change the format and appearance of selected cell(s), row(s) or column(s) use the option from the menu or from the mouse button popup menu.

This will bring up the Cell Format dialog box which has several tabbed pages:

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. A Preview pane allows you to see the effect of the new format.
You can set the same data format for a row or a column by selecting the row or column and calling the Cell Format dialog with the mouse button.
Note
You can increase the precision decimal for any number in Generic,
Number, Percent, Money or
Scientific formats using the Increase decimal
precision icon in the Format toolbar:
You can decrease the precision decimal for any number in Generic,
Number, Percent, Money or
Scientific formats using the Decrease decimal precision icon
in the Format toolbar:
- Generic
This is the default format and KSpread autodetects the actual data type depending on the current cell data. By default, KSpread right justifies numbers, dates and times within a cell and left justifies anything else.
If the Generic format does not suit you, you can change to a specific format among the choices below.
- Number
The number notation uses the notation you globally choose in KDE Control Center in → → . Numbers are right justified by default.
- Percent
When you have a number in the current cell and you switch the cell format from Generic to Percent, the current cell number will be multiplied by 100%.
For example if you enter 2 and set the cell format to Percent, the number will then be 200 %. Switching back to Generic cell format will bring it back to 2.
You can also use the Percent icon in the Format Toolbar:
- Money
The Money format converts your number into money notation using the settings globally fixed in KDE Control Center in → → . The currency symbol will be displayed and the precision will be the one set in