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.
Step 3: Right-click on the column letter, 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.
You will notice that the previously selected cells will now be formatted with a $ symbol in front of the numerical values.
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. After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites. His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well. Read his full bio here.
You may opt out at any time. Read our Privacy Policy
