How To Add Dollar Sign In Microsoft Excel [Tutorial]
296.7 هزار بار بازدید -
7 سال پیش
-
This brief tutorial will show
This brief tutorial will show you guys how to use currency symbols in Microsoft Excel.
Whether knowing how to use the dollar sign in Microsoft Excel is a need-to-know or a nice-to-know for you, the sign is something that will enable you to present your corporate accounting data more accurately. The application employs the sign as a programming convention in formulas. Placing a dollar sign before the column and the row in a formula tells Excel that you don’t want it to adjust the cell reference when you copy the formula. This is called an absolute cell reference. If you don’t include the dollar signs, then Excel adjusts the cell reference by following the same location-based pattern as your original formula, rather than the actual formula. Most people are familiar with the conventional use of the dollar sign in Excel, which is to express monetary values.
Currency Format
1. Select a range of cells to display with the dollar sign. You can also choose just one cell.
2. On the Home tab, click the dialog box launcher in the Number group. The launcher has the small, right-pointing arrow.
3. Click “Currency” from the Category list. To align the decimal points and the dollar signs, click “Accounting” instead. Otherwise, the dollar signs will appear immediately before each number. Also, if you type in a zero in a cell, applying the Accounting format will change the digit to a dash, whereas the Currency format will keep it as a numeral.
4. Select how many decimal places you want the numbers to have from the Decimal Places list. The up arrow goes all the way up to 30; the down arrow drops to zero. The dollar sign is preselected in the Symbol menu. Select a format for negative numbers from the Negative Numbers list.
5. Click “OK.”
Absolute Cell Reference
1. Select a blank cell and then enter a value in it, to use as an example. For example, select cell A1 and then type “15” (without quotation marks).
2. Select another blank cell and enter a formula in it that contains the cell reference in your example. For example, navigate to cell C4, type “=A1” (without quotation marks) and then press “Enter.” It should display “15” in the cell.
3. Copy the cell with your formula to another blank cell. For example, copy the formula in cell C4 to cell F4. Use whichever copy and paste operation you prefer. The cell should display “0.”
4. Navigate to the cell with the formula you initially created, not the copied cell. In the example, that would be C4. Click in the formula bar and type a dollar sign before the “A” and the “1,” so that it looks like this: $A$1. Press “Enter.”
5. Copy the newly created formula with the dollar signs into the same cell that you initially copied the formula into. In the example, that’s F4. The cell should now display “15” instead of “0.”
Whether knowing how to use the dollar sign in Microsoft Excel is a need-to-know or a nice-to-know for you, the sign is something that will enable you to present your corporate accounting data more accurately. The application employs the sign as a programming convention in formulas. Placing a dollar sign before the column and the row in a formula tells Excel that you don’t want it to adjust the cell reference when you copy the formula. This is called an absolute cell reference. If you don’t include the dollar signs, then Excel adjusts the cell reference by following the same location-based pattern as your original formula, rather than the actual formula. Most people are familiar with the conventional use of the dollar sign in Excel, which is to express monetary values.
Currency Format
1. Select a range of cells to display with the dollar sign. You can also choose just one cell.
2. On the Home tab, click the dialog box launcher in the Number group. The launcher has the small, right-pointing arrow.
3. Click “Currency” from the Category list. To align the decimal points and the dollar signs, click “Accounting” instead. Otherwise, the dollar signs will appear immediately before each number. Also, if you type in a zero in a cell, applying the Accounting format will change the digit to a dash, whereas the Currency format will keep it as a numeral.
4. Select how many decimal places you want the numbers to have from the Decimal Places list. The up arrow goes all the way up to 30; the down arrow drops to zero. The dollar sign is preselected in the Symbol menu. Select a format for negative numbers from the Negative Numbers list.
5. Click “OK.”
Absolute Cell Reference
1. Select a blank cell and then enter a value in it, to use as an example. For example, select cell A1 and then type “15” (without quotation marks).
2. Select another blank cell and enter a formula in it that contains the cell reference in your example. For example, navigate to cell C4, type “=A1” (without quotation marks) and then press “Enter.” It should display “15” in the cell.
3. Copy the cell with your formula to another blank cell. For example, copy the formula in cell C4 to cell F4. Use whichever copy and paste operation you prefer. The cell should display “0.”
4. Navigate to the cell with the formula you initially created, not the copied cell. In the example, that would be C4. Click in the formula bar and type a dollar sign before the “A” and the “1,” so that it looks like this: $A$1. Press “Enter.”
5. Copy the newly created formula with the dollar signs into the same cell that you initially copied the formula into. In the example, that’s F4. The cell should now display “15” instead of “0.”
7 سال پیش
در تاریخ 1396/02/24 منتشر شده
است.
296,707
بـار بازدید شده