Cell dsplays the Formula, NOT the result

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
 
B

Bob Phillips

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)
 
R

RagDyer

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)
 
R

RagDyer

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
 
K

Keith

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...
 
B

Bob Phillips

Thanks RD, we keep learning :).

Will be extra careful now I know that.

Regards

Bob
 
Top