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?
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
DILIPandey
+919810929744
dilipandey@gmail.com
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks