How do you add 0.001 to whole column in Microsoft Excel?

Answer 1

Put the cursor on the cell with 0.001 in it. Do a copy, using the Edit menu or Ctrl-C or clicking the copy icon on the toolbar or whatever your preferred method is. Then select the cells you want to add the 0.001 to or click on the column heading if it is every cell in the entire column that you want to add to. Go to the Edit menu and select Paste Special. In the dialog box that pops up, click on the radio button beside Add in the Operation part and then click OK. 0.001 will be added to all the selected cells. If you don't see it coming up, go to the Format menu and make sure the cells are formatted to have at least 3 decimal places.