Transerring subscripts to a new page using equation

[daqddyo1]

Hi All,

To transfer data (a chemical formula with subscripts) to another sheet, I am using =Sheet1!G9 to transfer a chemical equation from cell G9 in Sheet1 to a cell in Sheet2. Everything works fine except that the subscripted items are no longer subscripts. Is there a different equation I need to use or is there some setting to go to in my Excel 2003?

[dilipandey]

Hi daqddyo1,

You can try following options:-
1) Double click on that cell and press Enter
2) Write 1 somewhere in worksheet and copy it, now go to that cell and right click-Paste Special-> chooose radio buttons values and multiply
3) Attach the samle sheet

Regards,
DILIPandey

< click on below 'star' if this helps >
First change the format of cell to General and then apply formula