Skip wrote:
but I want to leave the formulas in the cells intact. Can this be
done?
Thanks for any help

Maybe this is what you want. Select the entire range of cells.

Edit / Go To / Special... / Constants / OK / Delete

If not, provide more details.