View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Michael
 
Posts: n/a
Default how to change a calculated cell to = the calculated value

Hi CAM. If you just want the values and not the formulas select all the
calculated cells, copy and then paste special - values before you save. HTH
--
Sincerely, Michael Colvin


"CAM" wrote:

I want to save a spreadsheet so that the values in the calculated cells are
changed to equal the calculated values so that the hidden data/formulas used
to calculate the values can then be removed. Any suggestions? Seemed like
there was such a technique in Lotus 123 days but I've slept way too many
times since then!