Use the "Paste Special" feature to control how data is pasted.
Right-click the destination cell, select Paste Special, and choose the appropriate option such as Values to avoid copying the formula or formatting.
If the problem persists, consider reinstalling Excel to fix any potential software corruption.