Write steps to apply currency symbol to salary column and steps to apply
borderto table.
please say fast it's so........ urgent please.....
please.................
write only correct answer
I will mark it as brainlist answer............................
Answers
Answer:
If you want to display numbers as monetary values, you must format those numbers as currency. To do this, you apply either the Currency or Accounting number format to the cells that you want to format. The number formatting options are available on the Home tab, in the Number group Format numbers as currency
You can display a number with the default currency symbol by selecting the cell or range of cells, and then clicking Accounting Number Format Accounting number format button in the Number group on the Home tab. (If you want to apply the Currency format instead, select the cells, and press Ctrl+Shift+$.)
If you want more control over either format, or you want to change other aspects of formatting for your selection, you can follow these steps.
Select the cells you want to format
On the Home tab, click the Dialog Box Launcher next to Number.
Tip: You can also press Ctrl+1 to open the Format Cells dialog box.
In the Format Cells dialog box, in the Category list, click Currency or Accounting.
Format Cells dialog box
In the Symbol box, click the currency symbol that you want.
Note: If you want to display a monetary value without a currency symbol, you can click None.
In the Decimal places box, enter the number of decimal places that you want for the number. For example, to display $138,691 instead of $138,690.63 in the cell, enter 0 in the Decimal places box.
As you make changes, watch the number in the Sample box. It shows you how changing the decimal places will affect the display of a number.
In the Negative numbers box, select the display style you want to use for negative numbers. If you don't want the existing options for displaying negative numbers, you can create your own number format. For more information about creating custom formats, see Create or delete a custom number format.
Note: The Negative numbers box is not available for the Accounting number format. That's because it is standard accounting practice to show negative numbers in parentheses.
To close the Format Cells dialog box, click OK.
If Excel displays ##### in a cell after you apply currency formatting to your data, the cell probably isn't wide enough to display the data. To expand the column width, double-click the right boundary of the column that contains the cells with the ##### error. This automatically resizes the column to fit the number. You can also drag the right boundary until the columns are the size that you want.
Column boundary being dragged
Top of Page
Remove currency formatting
If you want to remove the currency formatting, you can follow these steps to reset the number format.
Select the cells that have currency formatting.
On the Home tab, in the Number group, click General.
Cells that are formatted with the General format do not have a specific number format.
hope it helps tq
Answer:
You can format a table cell with a specific data format (for example, number, currency or percentage) that determines how data in the cell appears, and how it’s used in calculations.
You can also choose how many decimal places appear in cells that contain numbers, currency units or percentage values, even if the exact value entered in the cell has more decimal places than you want to show. The actual value entered is always the value used in calculations, regardless of how many decimal places appear in the cell. If a formula refers to text in a cell, the displayed value is used in the calculation.
You can change a cell’s format even if you already typed content in the cell. For example, if you have a table that shows your monthly budget, you can have a currency symbol (for example, a pound sign £) added to all cells automatically by formatting the cells as currency, then selecting the symbol you want.