Cell dsplays the Formula, NOT the result

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

I have experienced this a few times now, when I enter a formula into a cell
(could be something as simple as a SUM, when I press enter or tab, the
formula just sists there rather than displaying the result. I have also had
this happen to a cell that is displaying the result, but when I edit the
formula a;; I see is the formula.
This is not something that happens all the time, but when it does it is
annoying as I end up typing the formula into a cell a few columns to the
right and then dragging it to the cell I need it in.
I am using 2003 but have had the same thing happen in 2002 and 97

Any ideas
 
Sounds like you have the cell formatted as text.

To get out of it, avoiding your method, try this

Select the cell
Hit Ctrl-Shift-#
Then hit the F2 key
Enter

all should be a working formula now

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
What Bob really meant was:
Hit Ctrl-Shift- ~
Then hit the F2 key
Enter

The # will get you a date format ... unless you want a cell formatted to
dates?<g>


Regards,

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

Sounds like you have the cell formatted as text.

To get out of it, avoiding your method, try this

Select the cell
Hit Ctrl-Shift-#
Then hit the F2 key
Enter

all should be a working formula now

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Just like you always try to utilize the international date format Bob, we'll
have to do the same where it comes to keyboards.
My # is a shift 3 key.
My ~ is a shift ` key, which is the extreme left most key in the row of
number keys under the function keys, right under my <Esc> key.

I've been critisized for describing the keyboard shortcut to toggle Formula
view as <Ctrl> <~>.
I didn't realize that not every keyboard has the ~ as a shifted '.
--


Regards,

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

Moot point RD :-)

The Shift makes it ~.

But will correct in future. Thanks

Bob
 
Thanks to all, that helps a lot

Regards


RagDyer said:
Just like you always try to utilize the international date format Bob,
we'll
have to do the same where it comes to keyboards.
My # is a shift 3 key.
My ~ is a shift ` key, which is the extreme left most key in the row of
number keys under the function keys, right under my <Esc> key.

I've been critisized for describing the keyboard shortcut to toggle
Formula
view as <Ctrl> <~>.
I didn't realize that not every keyboard has the ~ as a shifted '.
--


Regards,

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

Moot point RD :-)

The Shift makes it ~.

But will correct in future. Thanks

Bob
Click to expand...
 
Back
Top