Originally Posted by JBeaucaire

The normal formula =A1 will give you the "value" from cell A1.

There is not formula (or even User Defined Function) that causes another cell to lose it's formula. Only a regular macro can do that, not a function.