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

  1. Open Excel and enter a new or existing workbook. 
  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. 
  3. Right-click and select Format Cells.
  4. Under the Number tab, choose 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. 
  6. Click OK.

10 Excel Business Tips You Need to Keep Your JobHow to Use Microsoft Outlook Like a Pro10 Microsoft Word Tips That Will Save Your Job