texbetty wrote:
I'm a self-taught Excel user (semi-intermediate level), although I'm having a
"formula" problem:
When I copy the "value" of a cell from cell A (which contains a formula)€¦.
And paste special to cell B (for value only)€¦. I don't want the contents in
cell A to change. I wish for them to stay as a formula. Can this be done?
My setting under TOOLS is for the calc = Automatic.
I use massive formulas on a month-to-month basis and have to constantly
double-check my "copied from formulas" to ensure they are edited back to a
formula.
texbetty
I don't understand why your cell "A" should change....copying FROM "A" will
leave it as it was
unless you have some other routine that changes it without your knowledge
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200706/1