The aspect of information in the cells of a spreadsheet can be modified by using the order Format Cells. At the launch of this order on the screen the dialog box appears Format Cells
The contents of the box varies depending on the selected button at the top of the window. Possible options are:
• Number – To change the format format
• Alignment – To change the type of alignment in the cell
• Font – for changing fonts
• Borders – To add border around the cells
• Patterns – To establish the background color in the cell
• Protection – To protect the information in the cell
Modification of the format format
Excel offers a wide range of numerical formats, which are presented in the following table:
| Format numeric | Example | Description |
| General | 10.7 (-10.7) | Excel displays the value as it is inserted. |
| Number | 3400.50(-120.39) | The predetermined format Number It has two decimals. Negative numbers appear written with red and between brackets, preceded by the minus sign. |
| Currency(Currency) | $3,400.50 ($3,400.50) | The predetermined format Currency It has two decimals and the symbol of the dollar. Negative numbers appear written with red and between brackets. |
| Accounting(Accounting) | $3,400.00$978.21 | This format is used to align the dollar symbol and decimals in the column. format Accounting Prestabilit contains two decimals and the symbol for the dollar. |
| Date(Data) | 11/7 | format Date predetermined includes the time and day separated from an oblique bar (/); However, another format can be selected from the available ones. |
| Time (now) | 10:00 | format Time Preset contains the time and minutes separated by two points; However, it can be opted for displaying seconds, or I have PM indicators. |
| Percentage(Percent) | 99.50% | format Percentage predetermined comprises two decimals. Excel multiplies the value of the cell by 100 displays the result accompanied by the symbol for percentage |
| Fraction(Fraction) | ⅛ | format Fraction Allows to display numbers in the form of a fraction. |
| Scientific(Scientific) | 3.40e+03 | format Scientific predetermined comprises two decimals. Use this format for displaying numbers in scientific format. |
| Text | 135RV90 | Use the format Text To display both text and numbers, in the same cell. Excel It will display exactly exactly what you introduce. |
| Special | 02110 | This format is specially designed for posting postcode, phone numbers and personal codes so that the use of special characters, such as dashes, is not necessary. |
| Custom (Personalized) | 00.0% | format Custom It is used to create its own numerical format. The formatting codes from the list can be used Type, which can be modified. The symbol # represents a booking mark for a number, 0 represents a reservation book for zero ,? To add a space |
After the appropriate numerical format is established, the following steps are performed:
1. Select the cell or cell area that contains the values to be formed.
2. The command is applied Format, Cells. On the screen will be displayed the dialog box Format Cells.
3. A click on the button is applied Number.
4. From the list Category, Select the format of numbers to be used.
5.. On the right side of the box, the desired changes are made on the selected format. For example, the number of decimals can be established with which the number will be displayed (in the list Decimal places), or the way in which negative numbers will be displayed (in the list Negative numbers).
6. Apply a click on the OK button, or press the key Enter. Excel will reform the selected cells according to the chosen options.
If a calendar date is introduced into a cell formed with format Number, The date will appear as a number (the serial number of the date). To solve the problem, the cell format from the cell in Number in Date.
Eliminating the numerical format from a cell or cell domain is done by applying the format General.
The formatting toolbar contains several buttons for establishing numerical formats. To use one of these buttons, select the cell or domain to be formatted, then apply a click on the desired button.
From the option Protection of the window Format Cells It allows the selected cell to be locked, this can only have an effect if we secure the spreadsheet in which the protected cell is located. This is done by accessing the section Protection FROM Tools.
Protective options are multiple: the current spreadsheet can be protected (Sheet), the whole file Excel (Workbook) or individual privileges for certain users for selective protection.
