K
Kris
Why is it when I copy a formula into a cell and hit enter, the formula is in
writing, in the cell itself?
Argh??
writing, in the cell itself?
Argh??
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.
J
Jacob Skaria
Make sure the cell is not formatted to 'Text'. Rigth click>Format
cells>number>Change to 'General' and try copying the formula..
If this post helps click Yes
cells>number>Change to 'General' and try copying the formula..
If this post helps click Yes
T
Tom Hutchins
The cell was probably already formatted as text. Select that cell and change
its format to General or some number or date format (whatever is
appropriate). Then press F2 and Enter.
Hope this helps,
Hutch
its format to General or some number or date format (whatever is
appropriate). Then press F2 and Enter.
Hope this helps,
Hutch
K
Kris
Jacob and Tom, Thanks for trying, but it did the same thing. I can't figure
out what is going wrong. Iv'e been up all night.
And to think I just yesterday finished my Class on Excell. I dislike this
part very much!
out what is going wrong. Iv'e been up all night.
And to think I just yesterday finished my Class on Excell. I dislike this
part very much!
J
John
Hi Kris
Maybe try press and hold the Ctrl button and press the "tilde" top left of the
keyboard before number 1.
This toggles the formula show/no show.
HTH
John
Maybe try press and hold the Ctrl button and press the "tilde" top left of the
keyboard before number 1.
This toggles the formula show/no show.
HTH
John