Good chance that the cell with the formula showing was pre-formatted as text.

Format to General and hit F2 then ENTER.

If all formulas are showing then try hitting the toggle key for "show formulas"

CTRL + ` backquote above Tab key


Gord Dibben MS Excel MVP

On Wed, 17 Oct 2007 08:30:15 -0700, Sisilla wrote:

Hello All,

Can anyone tell me why this formula will not work? I do not get any
error messages. The formula is displayed in the cell as its value.

=CONCATENATE(OFFSET(RC, 0, 0), IF(ISBLANK(OFFSET(RC, 0, 4)), "",
CHAR(10)), OFFSET(RC, 0, 4), IF(ISBLANK(OFFSET(RC, 0, 8)), "",
CHAR(10)), OFFSET(RC, 0, 8))


I appreciate any effort to help me. Thank you for your time and
consideration.

Sincerely,

Sisilla