software

I have a cell that refers to another cell (linked worksheet) and I need to
have the destination cell reflect the format of the reference cell,
especially if I change the format of the reference to a custom format
(lt;0.00). I need the cell value to remain a number for subsequent
calculations. My template is already fairly large and will need to be used
by novices so my solution needs to be as automatic as possible. Thanks.

Formulas, including links to other workbooks, can only return values--not
formats.

I think copy|paste special|formats either manually or via a macro is the way to
go.

(If you need a macro, record one when you do it manually.)

DBS wrote:
gt;
gt; I have a cell that refers to another cell (linked worksheet) and I need to
gt; have the destination cell reflect the format of the reference cell,
gt; especially if I change the format of the reference to a custom format
gt; (lt;0.00). I need the cell value to remain a number for subsequent
gt; calculations. My template is already fairly large and will need to be used
gt; by novices so my solution needs to be as automatic as possible. Thanks.

--

Dave Peterson

Thanks Dave,

I was hoping to avoid that as I am trying to keep my wookbook as simple and
automatic as possible. I don't want users to have to quot;rememberquot; to do
something different. I know if you create a new formula that refers to a
cell with data already in it, the new cell will take the format of the
reference cell (even a custom format). Based on that, I was hoping there was
some obscure function or switch that could do that more dynamically. I would
like to change the format of the original cell and have the linked cells
change with it. Another problem with paste specialgt;formats (either manual or
macro) is that it pastes all formatting which creates new problems for me. I
want the number format only. Once implemented, this template will have about
four hundred duplicates. Thanks for the reply. DBS

Anyone else?

quot;Dave Petersonquot; wrote:

gt; Formulas, including links to other workbooks, can only return values--not
gt; formats.
gt;
gt; I think copy|paste special|formats either manually or via a macro is the way to
gt; go.
gt;
gt; (If you need a macro, record one when you do it manually.)
gt;
gt; DBS wrote:
gt; gt;
gt; gt; I have a cell that refers to another cell (linked worksheet) and I need to
gt; gt; have the destination cell reflect the format of the reference cell,
gt; gt; especially if I change the format of the reference to a custom format
gt; gt; (lt;0.00). I need the cell value to remain a number for subsequent
gt; gt; calculations. My template is already fairly large and will need to be used
gt; gt; by novices so my solution needs to be as automatic as possible. Thanks.
gt;
gt; --
gt;
gt; Dave Peterson
gt;