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