Getting Old and forgot how to multiply a set of numbers in a column by a fixed number and have the results appear in the same column? Also round the results to two decimal places.
Type the number by which you want the column multiplied in some spare cell.
Select that cell and copy it (Ctrl+C).
Select the cells you want multiplied.
Right-click, Paste Special
One of the choices is "Multiply". Do that. This replaces each value with value x N
To DISPLAY fewer digits (while leaving the underlying number unedited) you can click the "Decrease Decimal" button (looks like this:
.00
->.0
To actually round the number in A1 to a certain number of digits (two digits in this example), use this formula in another cell: =ROUND(A1,2)
And here's an example of the difference between rounding to 2 decimal places and merely showing 2 decimal places. The sum in the "Show 2" column appears to be wrong. It's not, it's correctly summing the numbers including the non-displayed digits:
Understand...I usually use an example of 2 places and Round when I show an example of changing the price a certain %...interestingly over time there is little difference in the total but there can be real differences in individual items
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.