Cells only display formula
I can't see any reason whatsoever to feel dumb on this one. It does not seem
evident to me at all to change the cell to general. I am surprised this is
not in the regular help text so thank you Gord.
"Gord Dibben" wrote:
Very common problem so don't feel too dumb.
Gord
On Thu, 13 Jul 2006 11:09:02 -0700, waladd
wrote:
That did it, thanks. Feel a little dumb now, but thank you lol
"Gord Dibben" wrote:
Sounds like cell(s) formatted as text.
Re-format to general then F2 and ENTER
If you have a great whack of these to do.............
EditReplace
What: =
With: =
Replace all.
Gord Dibben MS Excel MVP
On Thu, 13 Jul 2006 09:22:02 -0700, waladd
wrote:
I have a formula that is not showing the result in the cells. Using fx button
shows result, but result does not show in cells. tried ctrl + ` to no avail,
formula is working.
ex. of formula:
=IF(Q34="ON","S",IF(Q34="PH","ON","OFF"))
any help or suggestions would be greatly appreciated
Gord Dibben MS Excel MVP
|