View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Larry E. Larry E. is offline
external usenet poster
 
Posts: 1
Default "Freezing" cell contents

At the end of each month, I want to "freeze" the results in various cells.
For example, if a cell using a formula results in "23" I want to change that
cell FROM a formula TO the value "23" so that it doesn't change again in the
future. (I know I could just type the result in, but I have many cells like
this.) Any functions or macros to do this??? Thanks for the help.

Larry