How to Format a Column in Excel to Currency

Microsoft Excel is a great way to keep a ledger for your financial records. Here are the steps to format your numbers into currency.

Difficulty: Easy

Instructions

Things You'll Need:

• Excel

1. Open excel

2. 
    
   Numbers

   In the first column, labeled "A", type in some numbers. It doesn't matter what they are for the example. You could also copy the numbers in the picture I have provided.

3. 
    
   Highlighted Numbers

   Highlight the column of numbers by clicking on the column header labeled "A".

4. 
    
   Pop up Menu

   Right click anywhere on the highlighted area to bring up the pop up menu as shown.

5. 
    
   Format Cells Window

   Select "Format Cells" from the pop up menu. This will bring up the format cells window.

6. In the list under the heading "Category", select the option, "Currency". Make sure you choose the appropriate symbol for your currency. In the U.S. it is $ (the dollar sign). Also choose the number of decimal places. The default is two.

7. 
    
   Formatted Numbers

   Click the ok button. You should now see your column of numbers formatted to currency.

Resources

• Click here to receive all of my How-To's by email.