ExcelBanter - swapping fomulas for values

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - swapping fomulas for values (https://www.excelbanter.com/excel-discussion-misc-queries/138516-swapping-fomulas-values.html)

tantrum9

swapping fomulas for values

Is there a way to use the value that is calculated in a cell and swap that
with the formula used to create it so a user can't see the calculation.

Gord Dibben

swapping fomulas for values

You could copy then paste specialvalues

Gord Dibben MS Excel MVP

On Tue, 10 Apr 2007 17:32:01 -0700, tantrum9
wrote:

Is there a way to use the value that is calculated in a cell and swap that
with the formula used to create it so a user can't see the calculation.

All times are GMT +1. The time now is 09:46 PM.