Peter, if the cell is formatted as text it will show the formula, could this
be the case?

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"pwermuth" wrote in
message ...

Hello,

I sometimes run into this phenomena where I change a formula or type in
a new formula and suddenly Excel keeps displaying the formula instead of
results.

This usually happens with a few cells only, i.e. the majority of the
cells just display regular results while only the few affected ones
display the formulas.

I am not in formula auditing mode, so I believe this is pretty much an
Excel bug. But what can I do about it?

Thanks,

Peter


--
pwermuth
------------------------------------------------------------------------
pwermuth's Profile:
http://www.excelforum.com/member.php...o&userid=24997
View this thread: http://www.excelforum.com/showthread...hreadid=387019