What Is the Excel Formula for Rounding Dollars and Cents and Showing Dollars Only?
You do not to create a formula to round money to dollars only. You can select the cells and then choose Format Cells/Currency. You can then choose the option that shows dollars only.
1 Additional Answer
The function is basically the same in the different versions of excel. Right click on the cell you want to format, click on the 'number' tab and then 'currency'. Change the decimal places to 0 and then the cents will not showl