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

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!