#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default 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?


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default 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?

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 120
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
subscript Mark Subscript Excel Discussion (Misc queries) 0 March 28th 07 02:14 AM
subscript Elkar Excel Discussion (Misc queries) 0 March 27th 07 11:38 PM
Subscript shortcut? Neight Excel Discussion (Misc queries) 1 June 2nd 06 09:07 PM
superscript/subscript Big Ron Excel Discussion (Misc queries) 3 January 21st 06 08:46 PM
Excel: how can I add a subscript 2 in H2O Janny Excel Discussion (Misc queries) 1 January 6th 06 01:58 PM


All times are GMT +1. The time now is 02:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"