formula in cell not showing result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,

i am typing a formular in a cell but instead of showing the result it is
showing the formula....how can i change the cell format to show the result???

thanks, leolin
 
It's possible the cell has been formatted as text, hence
your formula is not calculting. If so, do this:

1. Select the cell.
2. Press <Ctrl><Shift><~>. (short for formatting as
General)
3. Press F2.
4. Press <Enter>.

HTH
Jason
Atlanta, GA
 
It's part of this family of shortcuts:

[Ctrl][Shift][~] applies the General number format.



[Ctrl][Shift][$] applies the Currency number format with two decimal places
and negative values in parentheses.



[Ctrl][Shift][%] applies the Percentage number format with no decimal
places.



[Ctrl][Shift][^] applies the Scientific number format with two decimal
places.



[Ctrl][Shift][#] applies the Date format in the form 15-Mar-04.



[Ctrl][Shift][@] applies the Time format in the form 12:00 AM.



[Ctrl][Shift][!] applies the Number format with two decimal places,
thousands separator, and minus sign (-) for negative values.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------





2. Press <Ctrl><Shift><~>. (short for formatting as General)
Click to expand...

Nice tip!
 
Yeah, I found most of those by playing after seeing Jason's post, I just
didn't know you could apply a format with the keyboard.

--

HTH

RP
(remove nothere from the email address if mailing direct)


RagDyeR said:
It's part of this family of shortcuts:

[Ctrl][Shift][~] applies the General number format.



[Ctrl][Shift][$] applies the Currency number format with two decimal places
and negative values in parentheses.



[Ctrl][Shift][%] applies the Percentage number format with no decimal
places.



[Ctrl][Shift][^] applies the Scientific number format with two decimal
places.



[Ctrl][Shift][#] applies the Date format in the form 15-Mar-04.



[Ctrl][Shift][@] applies the Time format in the form 12:00 AM.



[Ctrl][Shift][!] applies the Number format with two decimal places,
thousands separator, and minus sign (-) for negative values.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------





2. Press <Ctrl><Shift><~>. (short for formatting as General)
Click to expand...

Nice tip!
Click to expand...
 
Allow me to bring up a side issue.

Recently (past 6 weeks), I've noticed that I'm not able to see the *entire*
thread in several cases each day in my O.E.
Also, I've noticed that other folks will post an almost exact suggestion
*hours* after the initial suggestion was posted by someone else, leading me
to believe that they (second poster) was not aware (couldn't see entire
thread) of the initial suggestion.

Your comment to Jason (nice tip), made me think that perhaps I'm not the
only person missing parts of threads, because I used that same suggestion in
a thread that you were part of.back on March 6.

http://tinyurl.com/3odc7

Maybe my post didn't come through to your machine.
I'm wondering if you are also experiencing the losing of posts.

Is this perhaps a problem with the MS servers, or with O.E., since I see
that you also use O.E.?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Yeah, I found most of those by playing after seeing Jason's post, I just
didn't know you could apply a format with the keyboard.

--

HTH

RP
(remove nothere from the email address if mailing direct)


RagDyeR said:
It's part of this family of shortcuts:

[Ctrl][Shift][~] applies the General number format.



[Ctrl][Shift][$] applies the Currency number format with two decimal places
and negative values in parentheses.



[Ctrl][Shift][%] applies the Percentage number format with no decimal
places.



[Ctrl][Shift][^] applies the Scientific number format with two decimal
places.



[Ctrl][Shift][#] applies the Date format in the form 15-Mar-04.



[Ctrl][Shift][@] applies the Time format in the form 12:00 AM.



[Ctrl][Shift][!] applies the Number format with two decimal places,
thousands separator, and minus sign (-) for negative values.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------





2. Press <Ctrl><Shift><~>. (short for formatting as General)
Click to expand...

Nice tip!
Click to expand...
 
RagDyer said:
Allow me to bring up a side issue.

Recently (past 6 weeks), I've noticed that I'm not able to see the *entire*
thread in several cases each day in my O.E.
Also, I've noticed that other folks will post an almost exact suggestion
*hours* after the initial suggestion was posted by someone else, leading me
to believe that they (second poster) was not aware (couldn't see entire
thread) of the initial suggestion.
Click to expand...

I came to that conclusion many months, maybe even years, ago. Often I may do
a Find in OE for a particular person, and it will throw up entries that I
cannot see in the NG thread. And how many times do you see someone saying
that they posted again because they didn't see their originalpost.

I often resort to Google to try and get a complete thread.
Your comment to Jason (nice tip), made me think that perhaps I'm not the
only person missing parts of threads, because I used that same suggestion in
a thread that you were part of.back on March 6.

http://tinyurl.com/3odc7

Maybe my post didn't come through to your machine.
I'm wondering if you are also experiencing the losing of posts.
Click to expand...

Could be that but it could be a couple of other things. Could just be that
my old brain read it and forgot it (I certainly won't forget this one now
:-). Also, I only watch some threads, even of those I join in on, and only
read some replies if I am not contributing or re-contributing. But there are
some people that I monitor in the NGs because I feel that they have an
interesting slant. Jason is one of these in WorksheetFunctions, and so if he
posts to a thread that I watching, then I will read it. So I read Jason's
reply whereas I may have missed an identical reply from someone else.
Is this perhaps a problem with the MS servers, or with O.E., since I see
that you also use O.E.?
Click to expand...

Indeed I am, and all of my excuses don't deflect from your main point. I do
also experience the missing posts.
 
Thanks for the verification of "missing posts".

Just this morning, have 2 answers with the OPs missing!
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


RagDyer said:
Allow me to bring up a side issue.

Recently (past 6 weeks), I've noticed that I'm not able to see the *entire*
thread in several cases each day in my O.E.
Also, I've noticed that other folks will post an almost exact suggestion
*hours* after the initial suggestion was posted by someone else, leading me
to believe that they (second poster) was not aware (couldn't see entire
thread) of the initial suggestion.
Click to expand...

I came to that conclusion many months, maybe even years, ago. Often I may do
a Find in OE for a particular person, and it will throw up entries that I
cannot see in the NG thread. And how many times do you see someone saying
that they posted again because they didn't see their originalpost.

I often resort to Google to try and get a complete thread.
Your comment to Jason (nice tip), made me think that perhaps I'm not the
only person missing parts of threads, because I used that same suggestion in
a thread that you were part of.back on March 6.

http://tinyurl.com/3odc7

Maybe my post didn't come through to your machine.
I'm wondering if you are also experiencing the losing of posts.
Click to expand...

Could be that but it could be a couple of other things. Could just be that
my old brain read it and forgot it (I certainly won't forget this one now
:-). Also, I only watch some threads, even of those I join in on, and only
read some replies if I am not contributing or re-contributing. But there are
some people that I monitor in the NGs because I feel that they have an
interesting slant. Jason is one of these in WorksheetFunctions, and so if he
posts to a thread that I watching, then I will read it. So I read Jason's
reply whereas I may have missed an identical reply from someone else.
Is this perhaps a problem with the MS servers, or with O.E., since I see
that you also use O.E.?
Click to expand...

Indeed I am, and all of my excuses don't deflect from your main point. I do
also experience the missing posts.
 
I also remember why I do this Find. Often I see a comment saying something
like '' according to the reply by Dave ...', and I can't see the reply from
Dave. Happens far too often.

Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula displays as a formula, not as its result 1
Match function: error due to format? 4
Why does forumula show in cell instead of formula result? 2
Excel VBA 1
Show the formula not the result 3
Formula result not showing in cell 2
cell displays 0 when formula is valid 2
Despite formula I use (for example SUM) result is always zero. 4

Back
Top