On Sat, 18 Dec 2004 11:59:11 -0800, Top Spin
wrote:

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

(1) None of the cell references are changed. That is, regardless 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.

I found out how to do this using Paste Special.

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

Paste Special will also do this, but in a separate step. Is there a
way to do it in one step? That is, copy the results and the formatting
all at once?

(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.


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