Formula to Copy Exact Value and Formatting

[cricha01]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello,
I am trying to create a formula in a cell on sheet 2 to exactly match a cell from sheet 1. The problem I am having is that I need to use 2 different fonts in the single cell. When I use the formula in a Sheet 2 cell ='Sheet1'!G170, it changes the Sheet 2 cell to be all one font.

Is there a way to exactly copy the cell from sheet 1 into sheet 2 and preserve the formatting? I need this to work for a number of cells and want to avoid simply copying and pasting.
Thank you.

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello,
I am trying to create a formula in a cell on sheet 2 to exactly match a cell
from sheet 1. The problem I am having is that I need to use 2 different fonts
in the single cell. When I use the formula in a Sheet 2 cell ='Sheet1'!G170,
it changes the Sheet 2 cell to be all one font.

Is there a way to exactly copy the cell from sheet 1 into sheet 2 and preserve
the formatting? I need this to work for a number of cells and want to avoid
simply copying and pasting.
Thank you.

There is no way to do this with out macros. As you discovered, copy and
paste will work=, but a formula can not do this. You could do it with an XLM
macro, or Apple Script, or wait till the next version of office is available
and use VBA.