subscript
 

When copying a cell with mixed format

i.e. H2O with the 2 in subscript is in cell A1,

If another cell contains =A1 the subscript format on the 2 is lost and H2O
is displayed. Is there anyway other than copy and paste to retaing the
formatting?

subscript
 

The short answer is no. You have to copy the cell. Formulas return values.
They do not return formats.
--
HTH...

Jim Thomlinson


"Bender" wrote:

When copying a cell with mixed format

i.e. H2O with the 2 in subscript is in cell A1,

If another cell contains =A1 the subscript format on the 2 is lost and H2O
is displayed. Is there anyway other than copy and paste to retaing the
formatting?

subscript
 

You could copy the formatted cell as a *picture*, therefore displaying it
with it's formats.

Select the formatted cell, and from the Menu Bar,
Hold <Shift and click on EDIT.

This gives you a slightly different drop down window.

Click on "Copy Picture", then <OK, then paste anywhere.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Bender" wrote in message
...
When copying a cell with mixed format

i.e. H2O with the 2 in subscript is in cell A1,

If another cell contains =A1 the subscript format on the 2 is lost and H2O
is displayed. Is there anyway other than copy and paste to retaing the
formatting?

subscript
 

You could use the camera tool

"Bender" wrote:

When copying a cell with mixed format

i.e. H2O with the 2 in subscript is in cell A1,

If another cell contains =A1 the subscript format on the 2 is lost and H2O
is displayed. Is there anyway other than copy and paste to retaing the
formatting?

subscript
 

You can use special fonts where sub- and superscripts occur as individual
characters. For facilitating the task:

http://www.tech-archive.net/Archive/.../msg00189.html

--
Petr Bezucha


"Bender" wrote:

When copying a cell with mixed format

i.e. H2O with the 2 in subscript is in cell A1,

If another cell contains =A1 the subscript format on the 2 is lost and H2O
is displayed. Is there anyway other than copy and paste to retaing the
formatting?