Formulas return values -- not formats.

=c2
or
=if(c2="","",c2)

would return the value from C2.

pskwaak wrote:

Excel 2007 - I need a formula for cell K2 that references the cell value of
the active row, column C. I would also like it to include the format of the
referenced cell, if possible.

--

Dave Peterson