VBA_Newbie
Active Member
- Joined
- Jan 7, 2005
- Messages
- 258
Hi folks,
I have a table of figures. Some of these figures have special meaning so I give them a custom format so that it is clearly visible to whomever is reading the table. For instance, suppose I decide that any value over 100 should have the letter "A" beside it (not actually the case, but it'll work for this example). So if the value is 101, I want the cell to appear as 101A (I still want to use the value of the cell for calculation, thus I do not format this as text). I was wondering if it was possible to do the same thing but have the letter "A" be a smaller font, or ideally, a subscript. Any ideas?
Many thanks.
I have a table of figures. Some of these figures have special meaning so I give them a custom format so that it is clearly visible to whomever is reading the table. For instance, suppose I decide that any value over 100 should have the letter "A" beside it (not actually the case, but it'll work for this example). So if the value is 101, I want the cell to appear as 101A (I still want to use the value of the cell for calculation, thus I do not format this as text). I was wondering if it was possible to do the same thing but have the letter "A" be a smaller font, or ideally, a subscript. Any ideas?
Many thanks.