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