C
ClimbGuy
How to I chainge the value a cell desplays to be the formual of the cell/
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
RagDyer
<Ctrl> <~>
Or, some people say:
<Ctrl> <`>
Any way, <Ctrl> plus the key to the left of the "1" and "!" key.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
How to I chainge the value a cell desplays to be the formual of the cell/
Or, some people say:
<Ctrl> <`>
Any way, <Ctrl> plus the key to the left of the "1" and "!" key.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
How to I chainge the value a cell desplays to be the formual of the cell/
C
ClimbGuy
That didn't seam to work maby i didn't do it right i am trying to make it so =1+1 will not only display 2 but have 2 as the cell value.
~Climbguy
~Climbguy
S
Stunn
Select the text of the formula within the cell and press F9. Note that this
is a permanent change.
is a permanent change.
so =1+1 will not only display 2 but have 2 as the cell value.ClimbGuy said:That didn't seam to work maby i didn't do it right i am trying to make it
G
Gord Dibben
Climb
Copy>Paste Special(in place)>Values>OK>Esc
So, your question really is "how do I change formulas to values?"
Gord Dibben Excel MVP
Copy>Paste Special(in place)>Values>OK>Esc
So, your question really is "how do I change formulas to values?"
Gord Dibben Excel MVP
S
Stunn
Hi Gord,
Don't know why I didn't think of that, perhaps it's getting a little too
late for me to be here...
Goodnight.
Steve D.
Don't know why I didn't think of that, perhaps it's getting a little too
late for me to be here...
Goodnight.
Steve D.
R
RagDyer
Nice to see that you're back with your handle.
Anyway ... can't see why you seem "down" or apologetic on the suggestion
that you posted.
It's a *much* easier and faster procedure for a one or two cell convert
(<F2> <F9>), as compared to the "standard" one that Gord mentioned, although
for multiple cells and ranges it definitely isn't.
--
Regards,
RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------
Hi Gord,
Don't know why I didn't think of that, perhaps it's getting a little too
late for me to be here...
Goodnight.
Steve D.
Anyway ... can't see why you seem "down" or apologetic on the suggestion
that you posted.
It's a *much* easier and faster procedure for a one or two cell convert
(<F2> <F9>), as compared to the "standard" one that Gord mentioned, although
for multiple cells and ranges it definitely isn't.
--
Regards,
RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------
Hi Gord,
Don't know why I didn't think of that, perhaps it's getting a little too
late for me to be here...
Goodnight.
Steve D.
S
Stunn
Hi RD,
Thanks for the welcome, it's good to be back, and seeing so many familiar
names still here!
Agreed for a couple of cells. For more than that, the key sequence by a
typist: Ctrl+c, Alt,e,s,v, is also pretty fast.
Cheers
Steve D.
Thanks for the welcome, it's good to be back, and seeing so many familiar
names still here!
Agreed for a couple of cells. For more than that, the key sequence by a
typist: Ctrl+c, Alt,e,s,v, is also pretty fast.
Cheers
Steve D.