Excel shows formula, not result
 

Help! I have a conditional formula that will not show the result. It shows
only the formula. Right now, the formulas box in the view tab under
tools/options is UNCHECKED and the formula still shows. I've tried checking
the box and it still shows. I really need my result in the cell and the day
is getting away from me...(Excel 2000)

Excel shows formula, not result
 

This may seem obvious, but is there an " = " sign in the cell before your
formula...?

"CMIConnie" wrote:

Help! I have a conditional formula that will not show the result. It shows
only the formula. Right now, the formulas box in the view tab under
tools/options is UNCHECKED and the formula still shows. I've tried checking
the box and it still shows. I really need my result in the cell and the day
is getting away from me...(Excel 2000)

Excel shows formula, not result
 

Your cell may be formatted as "text", format as "general" or "number" then
hit F2 and Enter.

HTH
JG

"ewan7279" wrote:

This may seem obvious, but is there an " = " sign in the cell before your
formula...?

"CMIConnie" wrote:

Help! I have a conditional formula that will not show the result. It shows
only the formula. Right now, the formulas box in the view tab under
tools/options is UNCHECKED and the formula still shows. I've tried checking
the box and it still shows. I really need my result in the cell and the day
is getting away from me...(Excel 2000)

Excel shows formula, not result
 

yes, it has an "=" sign before the formula. Someone just suggested checking
the format so I will check that... Thank you

"ewan7279" wrote:

This may seem obvious, but is there an " = " sign in the cell before your
formula...?

"CMIConnie" wrote:

Help! I have a conditional formula that will not show the result. It shows
only the formula. Right now, the formulas box in the view tab under
tools/options is UNCHECKED and the formula still shows. I've tried checking
the box and it still shows. I really need my result in the cell and the day
is getting away from me...(Excel 2000)

Excel shows formula, not result
 

Thank you! Thank you! Thank you! it worked! I love this site... now maybe I
can get this done :)

"pinmaster" wrote:

Your cell may be formatted as "text", format as "general" or "number" then
hit F2 and Enter.

HTH
JG

"ewan7279" wrote:

This may seem obvious, but is there an " = " sign in the cell before your
formula...?

"CMIConnie" wrote:

Help! I have a conditional formula that will not show the result. It shows
only the formula. Right now, the formulas box in the view tab under
tools/options is UNCHECKED and the formula still shows. I've tried checking
the box and it still shows. I really need my result in the cell and the day
is getting away from me...(Excel 2000)

Excel shows formula, not result
 

It seems strange, that's all. Even with a cell formatted as text, the
formula should still return the result... Try entering the formula with
ctrl+shift+enter.

"CMIConnie" wrote:

yes, it has an "=" sign before the formula. Someone just suggested checking
the format so I will check that... Thank you

"ewan7279" wrote:

This may seem obvious, but is there an " = " sign in the cell before your
formula...?

"CMIConnie" wrote:

Help! I have a conditional formula that will not show the result. It shows
only the formula. Right now, the formulas box in the view tab under
tools/options is UNCHECKED and the formula still shows. I've tried checking
the box and it still shows. I really need my result in the cell and the day
is getting away from me...(Excel 2000)

Excel shows formula, not result
 

Another possible option when Excel is showing Formulas is that the option to
show "Formulas" is turned on.
Tools | Options | "View Tab"
With a check on "Formulas"
One can toggle between both views with Ctrl + ` (Character to left of
number 1, usually with ~ character)

--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"ewan7279" wrote in message
...
It seems strange, that's all. Even with a cell formatted as text, the
formula should still return the result... Try entering the formula with
ctrl+shift+enter.

"CMIConnie" wrote:

yes, it has an "=" sign before the formula. Someone just suggested
checking
the format so I will check that... Thank you

"ewan7279" wrote:

This may seem obvious, but is there an " = " sign in the cell before
your
formula...?

"CMIConnie" wrote:

Help! I have a conditional formula that will not show the result.
It shows
only the formula. Right now, the formulas box in the view tab under
tools/options is UNCHECKED and the formula still shows. I've tried
checking
the box and it still shows. I really need my result in the cell and
the day
is getting away from me...(Excel 2000)

Excel shows formula, not result
 

It is strange... I formated it as a number and it worked. It is a huge
spreadsheet (over 7000 rows) so maybe that has something to do with it. but
it is working now so that's okay with me :)

"ewan7279" wrote:

It seems strange, that's all. Even with a cell formatted as text, the
formula should still return the result... Try entering the formula with
ctrl+shift+enter.

"CMIConnie" wrote:

yes, it has an "=" sign before the formula. Someone just suggested checking
the format so I will check that... Thank you

"ewan7279" wrote:

This may seem obvious, but is there an " = " sign in the cell before your
formula...?

"CMIConnie" wrote:

Help! I have a conditional formula that will not show the result. It shows
only the formula. Right now, the formulas box in the view tab under
tools/options is UNCHECKED and the formula still shows. I've tried checking
the box and it still shows. I really need my result in the cell and the day
is getting away from me...(Excel 2000)

Excel shows formula, not result
 

I may be wrong but I think it depends on when the cell was formatted. If the
cell was pre-formatted as text and you enter the formula then the formula
will show as text, if however you format the cell after the formula was
entered then the result will be text not the formula but if you re-enter the
formula while the cell is formatted as text then the formula will turn back
into text.

Regards
Jean-Guy

"ewan7279" wrote:

It seems strange, that's all. Even with a cell formatted as text, the
formula should still return the result... Try entering the formula with
ctrl+shift+enter.

"CMIConnie" wrote:

yes, it has an "=" sign before the formula. Someone just suggested checking
the format so I will check that... Thank you

"ewan7279" wrote:

This may seem obvious, but is there an " = " sign in the cell before your
formula...?

"CMIConnie" wrote:

Help! I have a conditional formula that will not show the result. It shows
only the formula. Right now, the formulas box in the view tab under
tools/options is UNCHECKED and the formula still shows. I've tried checking
the box and it still shows. I really need my result in the cell and the day
is getting away from me...(Excel 2000)