Changing formula to a value

  • Thread starter Thread starter newbie101
  • Start date Start date
N

newbie101

Hello,

I was wondering whether there is a function in Excel (or if it is
possible to write a Macro) that allows you to change the formula within
a given cell to just its value (that the formula calculated), if a
certain condition is met.

For example...cells will be populated for the March coloumn from the
March data spreadsheet. As soon as March is over, the values in the
March coloumn will be fixed, and the formulas within those cells will
be disabled.


Thank you!
 
1) Select and Copy the cells
2) With cells still selected, use Edit | Paste Special with Values checked.
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help with sum / count formula 9
determine a range using a formula 2
Can a formula be "built" referencing text content from another cel 3
SUMPRODUCT NON-CONTINOUS CELL 2
Problems 6
Re-post Formula 2
Define variable range input for SUM() function 8
Sum Every 4th column in a range tied to a control cell 1

Back
Top