subscript

[Bender]

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?

 

[Jim Thomlinson]

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

 

[RagDyeR]

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!
=====================================================

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?

 

[Ethoros]

You could use the camera tool

 

[PBezucha]

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

http://www.tech-archive.net/Archive/Excel/microsoft.public.excel.charting/2007-07/msg00189.html