select all such cells.

do edit =Copy
then immediatly do Edit=Paste special and select just Values.

This will do what you describe.

--
Regards,
Tom Ogilvy

"Task Lead Nicole" wrote in
message ...
Is there any way to break (get rid of) the formulas on a sheet (which the
data from another sheet to populate this sheet) but keep the data?