Precede the formula with an apostrophe
Micky


"Louise" wrote:

i am trying to enter a formula in a cell, but it is coming up as a value.
how do i change it from value to formula.
--
Louise