software

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)

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

quot;CMIConniequot; wrote:

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

Your cell may be formatted as quot;textquot;, format as quot;generalquot; or quot;numberquot; then
hit F2 and Enter.

HTH
JG

quot;ewan7279quot; wrote:

gt; This may seem obvious, but is there an quot; = quot; sign in the cell before your
gt; formula...?
gt;
gt; quot;CMIConniequot; wrote:
gt;
gt; gt; Help! I have a conditional formula that will not show the result. It shows
gt; gt; only the formula. Right now, the formulas box in the view tab under
gt; gt; tools/options is UNCHECKED and the formula still shows. I've tried checking
gt; gt; the box and it still shows. I really need my result in the cell and the day
gt; gt; is getting away from me...(Excel 2000)

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

quot;ewan7279quot; wrote:

gt; This may seem obvious, but is there an quot; = quot; sign in the cell before your
gt; formula...?
gt;
gt; quot;CMIConniequot; wrote:
gt;
gt; gt; Help! I have a conditional formula that will not show the result. It shows
gt; gt; only the formula. Right now, the formulas box in the view tab under
gt; gt; tools/options is UNCHECKED and the formula still shows. I've tried checking
gt; gt; the box and it still shows. I really need my result in the cell and the day
gt; gt; is getting away from me...(Excel 2000)

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

quot;pinmasterquot; wrote:

gt; Your cell may be formatted as quot;textquot;, format as quot;generalquot; or quot;numberquot; then
gt; hit F2 and Enter.
gt;
gt; HTH
gt; JG
gt;
gt; quot;ewan7279quot; wrote:
gt;
gt; gt; This may seem obvious, but is there an quot; = quot; sign in the cell before your
gt; gt; formula...?
gt; gt;
gt; gt; quot;CMIConniequot; wrote:
gt; gt;
gt; gt; gt; Help! I have a conditional formula that will not show the result. It shows
gt; gt; gt; only the formula. Right now, the formulas box in the view tab under
gt; gt; gt; tools/options is UNCHECKED and the formula still shows. I've tried checking
gt; gt; gt; the box and it still shows. I really need my result in the cell and the day
gt; gt; gt; is getting away from me...(Excel 2000)

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.

quot;CMIConniequot; wrote:

gt; yes, it has an quot;=quot; sign before the formula. Someone just suggested checking
gt; the format so I will check that... Thank you
gt;
gt; quot;ewan7279quot; wrote:
gt;
gt; gt; This may seem obvious, but is there an quot; = quot; sign in the cell before your
gt; gt; formula...?
gt; gt;
gt; gt; quot;CMIConniequot; wrote:
gt; gt;
gt; gt; gt; Help! I have a conditional formula that will not show the result. It shows
gt; gt; gt; only the formula. Right now, the formulas box in the view tab under
gt; gt; gt; tools/options is UNCHECKED and the formula still shows. I've tried checking
gt; gt; gt; the box and it still shows. I really need my result in the cell and the day
gt; gt; gt; is getting away from me...(Excel 2000)

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

--
HTH. :gt;)
Dana DeLouis
Windows XP, Office 2003quot;ewan7279quot; gt; wrote in message
...
gt; It seems strange, that's all. Even with a cell formatted as text, the
gt; formula should still return the result... Try entering the formula with
gt; ctrl shift enter.
gt;
gt; quot;CMIConniequot; wrote:
gt;
gt;gt; yes, it has an quot;=quot; sign before the formula. Someone just suggested
gt;gt; checking
gt;gt; the format so I will check that... Thank you
gt;gt;
gt;gt; quot;ewan7279quot; wrote:
gt;gt;
gt;gt; gt; This may seem obvious, but is there an quot; = quot; sign in the cell before
gt;gt; gt; your
gt;gt; gt; formula...?
gt;gt; gt;
gt;gt; gt; quot;CMIConniequot; wrote:
gt;gt; gt;
gt;gt; gt; gt; Help! I have a conditional formula that will not show the result.
gt;gt; gt; gt; It shows
gt;gt; gt; gt; only the formula. Right now, the formulas box in the view tab under
gt;gt; gt; gt; tools/options is UNCHECKED and the formula still shows. I've tried
gt;gt; gt; gt; checking
gt;gt; gt; gt; the box and it still shows. I really need my result in the cell and
gt;gt; gt; gt; the day
gt;gt; gt; gt; is getting away from me...(Excel 2000)
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

quot;ewan7279quot; wrote:

gt; It seems strange, that's all. Even with a cell formatted as text, the
gt; formula should still return the result... Try entering the formula with
gt; ctrl shift enter.
gt;
gt; quot;CMIConniequot; wrote:
gt;
gt; gt; yes, it has an quot;=quot; sign before the formula. Someone just suggested checking
gt; gt; the format so I will check that... Thank you
gt; gt;
gt; gt; quot;ewan7279quot; wrote:
gt; gt;
gt; gt; gt; This may seem obvious, but is there an quot; = quot; sign in the cell before your
gt; gt; gt; formula...?
gt; gt; gt;
gt; gt; gt; quot;CMIConniequot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Help! I have a conditional formula that will not show the result. It shows
gt; gt; gt; gt; only the formula. Right now, the formulas box in the view tab under
gt; gt; gt; gt; tools/options is UNCHECKED and the formula still shows. I've tried checking
gt; gt; gt; gt; the box and it still shows. I really need my result in the cell and the day
gt; gt; gt; gt; is getting away from me...(Excel 2000)

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

quot;ewan7279quot; wrote:

gt; It seems strange, that's all. Even with a cell formatted as text, the
gt; formula should still return the result... Try entering the formula with
gt; ctrl shift enter.
gt;
gt; quot;CMIConniequot; wrote:
gt;
gt; gt; yes, it has an quot;=quot; sign before the formula. Someone just suggested checking
gt; gt; the format so I will check that... Thank you
gt; gt;
gt; gt; quot;ewan7279quot; wrote:
gt; gt;
gt; gt; gt; This may seem obvious, but is there an quot; = quot; sign in the cell before your
gt; gt; gt; formula...?
gt; gt; gt;
gt; gt; gt; quot;CMIConniequot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Help! I have a conditional formula that will not show the result. It shows
gt; gt; gt; gt; only the formula. Right now, the formulas box in the view tab under
gt; gt; gt; gt; tools/options is UNCHECKED and the formula still shows. I've tried checking
gt; gt; gt; gt; the box and it still shows. I really need my result in the cell and the day
gt; gt; gt; gt; is getting away from me...(Excel 2000)