How to Automatically Add a Dollar Symbol in Excel 2010

Excel can be used in a lot of different ways, but perhaps one of the most common uses is generating reports that include monetary values. In many ways this data is similar to normal numbers, but a person that is viewing your spreadsheet might prefer to see a $ symbol in front of data that is a monetary amount. Fortunately you can format your cells in Excel 2010 to have this symbol be automatically entered in front of the values that you enter by formatting your cells as currency.


Include a $ Symbol When Entering Numbers in Excel 2010

This tutorial is going to focus on formatting a specific column of data as currency values. You can, however, select a row number or a specific group of cells that you want to format instead of selecting an entire column, as we will be doing in the steps below.


Step 1: Open your spreadsheet in Excel 2010.


Step 2: Click the letter of the column that you want to format as currency to select the entire column. As mentioned previously, you can also click a row number to select the entire row, or you can manually highlight a group of cells that you want to format.

select the cells that you want to format with the dollar symbol



Step 3: Right-click on the column letter, then click Format Cells.

right-click the sleected cells, then click format cells



Step 3: Click the Number tab at the top of the window, then click Currency in the column at the left side of the window. You can also specify the number of decimal places that you want to use, if you do not want to use the default of 2 decimal places. Click OK at the bottom of the window to apply these changes.

click currency, then click the ok button



You will notice that the previously selected cells will now be formatted with a $ symbol in front of the numerical values.

how to automatically insert a dollar symbol in excel 2010



Do you need to print your spreadsheet, but you are having trouble getting it to print on one page? Learn how to automatically fit all of your columns on one page in Excel 2010. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.