Simply re-formatting to General will not do the trick.

After the format to General you must go to each cell and F2 + ENTER to reenter
the formula.


Gord Dibben MS Excel MVP

On Mon, 4 Sep 2006 02:53:01 -0700, ViestaWu wrote:

Hello Martin,

I think you have found the reason, cause I have tested the function with
other columns which are predefined as "General", but it still not work with
those two columns, which are predefined as "text", though I changed back them
to "General", it still doesn't work with functions.

For these problem, do you have any more good idea, which let me keep cell
formats as "Text"?

BR
Viesta

"MartinW" wrote:

Hi Viesta,

Was the cell preformatted to text before you entered your formula?
Try deleting the cell, reformat it to general, then enter your formula
again.

HTH
Martin