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

-----Original Message-----
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
.

"Jason Morin" wrote in message
...


2. Press <Ctrl<Shift<~. (short for formatting as General)

Nice tip!

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 !
--------------------------------------------------------------------



"Bob Phillips" wrote in message
...

"Jason Morin" wrote in message
...


2. Press <Ctrl<Shift<~. (short for formatting as General)

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" wrote in message
...
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 !
--------------------------------------------------------------------



"Bob Phillips" wrote in message
...

"Jason Morin" wrote in message
...


2. Press <Ctrl<Shift<~. (short for formatting as General)

Nice tip!

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!
-------------------------------------------------------------------

"Bob Phillips" wrote in message
...
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" wrote in message
...
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 !
--------------------------------------------------------------------



"Bob Phillips" wrote in message
...

"Jason Morin" wrote in message
...


2. Press <Ctrl<Shift<~. (short for formatting as General)

Nice tip!