Office2 lets you define cells as a specific type. You can select from the following types:
Office2 lets you define cells as a specific type. You can select from the following types:
- General
- Number
- Currency
- Percentage
- Date
- Time
- Date/Time
- Text
By default, all cells are General type. This means that spreadsheet will interpret how to display the contents of the cell according to the data stored within the cell.
It is possible to enforce a specific display format by changing the cell type. For example, you may wish to display all numbers within a range of cells as dollar values with two decimal places. To do this select the appropriate cell or range of cells and show the Cell Types page by pressing the format button located in the toolbar and selecting the Type button in the tab bar at the bottom of the screen.
Now press down in the Type row. You will be presented with a list of cell types to choose from. Press on Currency. The view will return to the Cell Type page. Further options will appear allowing you to select the number of decimal places that you wish to show and the currency symbol that you wish to show. You can choose from either the dollar, euro, sterling or yen currency symbols.
You may also choose whether the currency symbol preceeds the number or whether it follows the number. Finally, you may choose how to display negative numbers. You have the option of displaying negative numbers with a negative symbol preceeding the number, or instead by showing the number in brackets.
The decimal places and negative numbers options are available if you choose the Number type, however in addition, you may choose whether or not to show large numbers separated by a thousand separator, e.g. 1000,000 instead of 1000000. Pressing Save in the Cell Type page will save the changes and will return you to the worksheet view.