Does this occur with all formulas?

Perhaps you are in Formula View. Hit CTRL + `(backquote above Tab key)

OR

The cell was pre-formatted as Text.

Format to General then hit F2 then ENTER to re-enter the formula.


Gord Dibben MS Excel MVP

On Sun, 27 May 2007 16:44:01 -0700, Nenagh
wrote:

Hi

I have used the concatenate formula, and it is coreect, however the only
thing displaying in the cell is the formula and not the value, what do i do
to make the value display?
Cheers