Applying number format from referenced cell

D

DBS

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

Dave Peterson

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.)
 
D

DBS

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 "remember" 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 special>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?
 
Top