title: Excel - replace a formula cell with its result automatically
body: <p>I am trying to make a sheet to add to templates that I give to my students for homework assignments; some of them are cheating by sending each other the files and I would like to catch them. </p>
  
  <p>I have made a formula cell that populates with the current OS and directory of the file. What I would like to do is have this become text after evaluation so that if another student opens the file it will not change (but the following cell will, and so on..) Here is the formula: </p>
  
  <p>(Cell A1):
  <code>=INFO("osversion")&amp;INFO("directory")</code></p>
  
  <p>(Cell A2 and beyond):
  <code> =IF(A1=(INFO("osversion")&amp;INFO("directory")),"",IF(LEN(A1)&lt;2," ",INFO("osversion")&amp;INFO("directory"))) </code></p>
  
  <p>Do you know if there is any way to have a formula cell be replaced by its value after execution without using VBA? (If I use VBA it asks if you want to enable macros on startup which kind of gives the game away...)</p>
  
  <p>Thank you in advance for your help! </p>