A copied calculation brought bold text and a fill you do not need. D2 shows 24 from =B2*C2. Clear the style while keeping the formula.

Choose Clear Formats on the intended range

Select D2 or the small range to clean. In Ulet choose Home → Clear → Clear Formats. Read the selected range before applying the command so adjacent cells keep their styling.

Clear Formats is applied to a styled calculation in D2.

Illustrated command choice. Select only the cells you want to restyle.

Check the formula bar and try one input

Select D2 again and confirm the formula remains. In a copy, use inputs 6 and 4, then change 4 to 5. The result should move from 24 to 30. If a nearby percentage now appears as 0.25, reapply its percentage format and check that it reads 25%.

The formula bar still shows =B2*C2 and a new input changes the result.

Illustrated calculation check. Reapply meaningful number formats where needed.

Microsoft’s reference for clearing formats and contents