I know we are in a round robin here, you don't understand what I'm saying and I don't understand what you're trying to accomplish.



Based on everything you've said, if you want to enter a formula into D1 to get the "value" to appear that is the result of the formula in C1, then the formula to enter into D1 would be:

=C1


There is no formula you can enter into D1 that will then delete itself leaving only the flat value behind. Formulas can only display values, they can't delete themselves. Only VBA can do that.