I have a formula in a cell that returns # value. The formula is
=CONCATENATE(D9," ",E9,F9,)

The Column D is formated to Text and both E and F are General. My problem is
that when I type a value in E9, the #Value! is returned

Any ideas on whats causing this?

I've just worked it out, for everyone elses benefit

As I had checked Transition Formula Evaluation and Transition Formula Entry
it caused it.

Not sure why that might be


"John" wrote in message
...
I have a formula in a cell that returns # value. The formula is
=CONCATENATE(D9," ",E9,F9,)

The Column D is formated to Text and both E and F are General. My problem
is
that when I type a value in E9, the #Value! is returned

Any ideas on whats causing this?

Hi
what exact values are in your cells. also try the following instead:
=D9 & " " & E9 & F9

--
Regards
Frank Kabel
Frankfurt, Germany

"John" schrieb im Newsbeitrag
...
I have a formula in a cell that returns # value. The formula is
=CONCATENATE(D9," ",E9,F9,)

The Column D is formated to Text and both E and F are General. My
problem is
that when I type a value in E9, the #Value! is returned

Any ideas on whats causing this?