Select the cell, then menu FormatCellsNumber and select General. Then hit
F2 and then Enter. Should clear it.

--

HTH

Bob

"Rene" wrote in message
...
Thanks Mike. It seems to work. I'll test the whole database to be sure
:)
Another question: the index formula messed up when I extended the database
and now returns the formula itself instead of the result

=index(i2:at2,match(b2,g2:at2,o)

Trying to use a formula that will return the text of a cell in the min
group
"winner"

"Mike H" wrote:

Hi,

Maybe something like the in G2 & O2

=IF(N2<"",K2/N2,"")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Rene" wrote:

b2 =min(g2,o2,w2,ae2)
g2 =k2/n2
o2 =s2/v9
...

b2 works when all the cell formulas have data to compute, but does not
work
when one of the formulas returns the error msg #div (no data)

Thanks for your help