Re: Cell dsplays the Formula, NOT the result

From: RagDyer (ragdyer_at_cutoutmsn.com)
Date: 03/23/05 

Date: Tue, 22 Mar 2005 18:44:32 -0800

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!
-------------------------------------------------------------------
"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:eni%23gDyLFHA.2988@TK2MSFTNGP14.phx.gbl...
Moot point RD :-)
The Shift makes it ~.
But will correct in future. Thanks
Bob
"RagDyer" <ragdyer@cutoutmsn.com> wrote in message
news:%235nImzxLFHA.3336@TK2MSFTNGP09.phx.gbl...
> 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!
> -------------------------------------------------------------------
>
> "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> news:%23qFqTnsLFHA.2120@TK2MSFTNGP10.phx.gbl...
> 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)
>
>
> "Keith" <zzz@DELETE.blueyonder.co.uk> wrote in message
> news:idP%d.115180$y25.34512@fe3.news.blueyonder.co.uk...
> >
> > 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
> >
> >
>
>

Relevant Pages

  • Re: multipage columns
    ... >Hi Bob ... >language in the right cell. ... >If you don't want lines around the cells, use Format> ... >Jay Freedman ...
    (microsoft.public.word.pagelayout)
  • Re: DTPicker
    ... On the BestFit issue, for every cell of the column in the Flexgrid, I have ... I could not come up with a generic format to fit no matter ... > Hi Bob, ...
    (microsoft.public.vb.controls)
  • Re: How do I setup a cell in Excel as a checkbox w/o a form/active
    ... I am using a Dell USB keyboard on a desktop computer. ... keypad. ... Maybe just give the cell a custom format. ... Hit the delete key on the keyboard to clear the cell. ...
    (microsoft.public.excel.misc)
  • Re: Formatting Cell Using Formulae....advise please....
    ... I do understand what the Proper function does now, but it does not do for me ... What is the most commonly used way to format text in a spreadsheet for best ... > Hi Bob, ... >> On the first point, you would enter the PROPER formula in an adjacent cell, ...
    (microsoft.public.excel.misc)
  • Re: 2 Conditiaonal Formatting
    ... "Bob" Thanx so much for replying, ... only show when its a value, say it returns $1000.00, but else when the shade ... >> some columns which was before like this CELL VALUE IS LESS THEN 0, FORMAT ...
    (microsoft.public.excel.misc)
Loading