Forum Discussion
"Freeze" results of a cell formula
I have an excel spreadsheet used to keep a log of a system's behavior. A cell in each log entry depends on a configuration variable that can be changed as time (days) go by. I would like each log ent...
I think I can state this more clearly...
Can I cause a cell with a formula to replace it's formula with the value resulting from the formula?
I know I can cut and paste to make that happen but I don't want to go through those steps as they are error prone or easily skipped by mistake. Ideally it would happen automatically, perhaps as the date changes. Old entries would be frozen.