Losing subscript/superscript! Help!

[hello_lpc]

Hi all,
Here is my problem:
When I type "H2O" in A1 cell (with subscript "2"), I found that if I
type "=a1" in B1 cell, it will only give back "H2O" (no subscript!).
I know direct copying from one cell to another is okay, but is there
any other method to keep the subscript?

Thanks!

George Lin

--
hello_lpc
------------------------------------------------------------------------
hello_lpc's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31304
View this thread: http://www.excelforum.com/showthread.php?threadid=511729

[Pete_UK]

A formula can't be used to copy formats. As you say, a direct copy of
the cell will work, also you could use <copy> Edit | Paste Special |
Formats | OK, but this will still not allow a formula in the second
cell.

Hope this helps.

Pete

[hello_lpc]

Hi Pete,
So, r u saying that there is no way to copy format by using
formula:confused: Oh my god...:(

[Bernard Liengme]

If you one the cell with H2O and copy the entry in the Formula Bar, then you
can paste the result to another cell
Also: you can set up Autocorrect to change H2O to H2O with subscript
AND: if you are a chemist, you should get the addin from
http://spectrum.troy.edu/~cking/ChemFormat/
I used this for years when preparing exams and papers!
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"hello_lpc" <hello_lpc.2369sn...@excelforum-nospam.com> wrote
in message news:hello_lpc.2369sn...@excelforum-nospam.com...