Copy the values the numbers formatting but not the underlying formulas of cells k4:k6 into range B4:B6
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.