How to Add Decimal Points Automatically in Excel

  • MORE

There’s nothing more annoying than adding a decimal point, only to have Excel remove it. Or, worse still, adding decimals to every line, even though you’re using whole numbers in dollar format -- $12.00 shouldn’t require you to type a decimal point on each line, instead let it Excel do it for you.

hero_decimalThis all comes down to formatting, and thankfully, it really couldn’t be easier.

  1. Open Excel and enter a new or existing workbook. 
    new_decimal
  2. Select the the column you’d like to add decimal points to. It doesn’t matter if there are no decimals, all decimals, or a mix of the two. 
    select_decimal
  3. Right-click and select Format Cells.
    format_decimal
  4. Under the Number tab, choose Currency. 
    currency
  5. The number of decimal places should be set to 2. If not, use the up/down arrows to select the number of decimal places (or just type it in). If it’s already set to 2, skip this step. 
    ok_decimal
  6. Click OK.
Add a comment