Copy the values the numbers formatting but not the underlying formulas of cells k4:k6 into range B4:B6

Answer 1

To copy the values of cells K4:K6 without copying the underlying formulas into range B4:B6, you can follow these steps:

1. Select cells K4:K6.
2. Right-click and select "Copy" or press Ctrl + C.
3. Select range B4:B6.
4. Right-click and select "Paste Special."
5. In the Paste Special dialog box, select "Values" and click "OK."

This will paste only the values from cells K4:K6 into range B4:B6 without copying the underlying formulas.