FORMULA NOT SHOWING VALUE

N

Nenagh

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
 
G

Gord Dibben

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
 
Top