Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formating issues
I have some words/texts in different cells, where I have Subscripts and
Superscripts. I have IF conditoins in other cells that copies those texts. but Subscripts and Superscripts are showing up as normal texts. Is there a way to keep them same format. (want to keep the sub/super scripts). please help, I really need to keep them in their original format. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formating issues
No, not using a formula... individual characters can be formatted
differently from other characters in a cell only if the entire cell value is a text constant... formula are not text constants. There is a possibility that you can do what you want using VB event programming (to replace the formulas), but you will have to describe your layout for us, show us your IF formula and tell us the range of cells the formula will cover before we can write that code for you. -- Rick (MVP - Excel) "Raz" wrote in message ... I have some words/texts in different cells, where I have Subscripts and Superscripts. I have IF conditoins in other cells that copies those texts. but Subscripts and Superscripts are showing up as normal texts. Is there a way to keep them same format. (want to keep the sub/super scripts). please help, I really need to keep them in their original format. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Formating Issues | Excel Discussion (Misc queries) | |||
Formula issues | Excel Worksheet Functions | |||
Rounding Issues | Excel Discussion (Misc queries) | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
formating issues when printing using different printers | Setting up and Configuration of Excel |