I would like to know how to copy a range of cells so that:

(1) None of the cell references are changed. That is, regadless of
whether the formulas use relative or absolute references, the formulas
that are copied to the target cells are exactly like the ones in the
source cells.

(2) Copy the results of the formulas. So if the cells shows "100", but
the call actually contains "=A3/B4", I would like the target cell to
get the "100", not the formula.

(2a) I would like it to carry the formatting with it.

(3) Is there a way to "convert" a cell from a formula to a result so
that, in the example above, the "=A3/B4" gets converted to "100" and
is no longer a formula? I am looking for the equivalent to Ctrl+6 in
Word that converts a field (like a date) into regular text.

Thanks

--
Email: Usenet-20031220 at spamex.com
(11/09/04)