Formatting Half of the Cell data in formula

[gnaga]

Hi,

I have a formula in Cell C1 "=Text(A1,"0.00") & $B$1"

I have a number in A1 and a Text in B1

While displaying this in C1, I would like to have bigger font for the number and smaller font for the text in order to accommodate within the width of cell C1.

How to achieve this task? Kindly help me.

TIA
GNAGA

 

[gnaga]

You are correct... you cannot format parts of a cell differently from the rest of the cell if the cell contains a formula, you can only do that if the cell contains a constant.




The formula is simple enough so it would be easy enough to create an event procedure to place text in the cell that is identical to what that formula would display... I don't think doing so would create any additional problems on the sheet. To write such an event procedure, the OP would need to tell us the starting cell for his formula and the sizes to make the numerical and text sizes.

As I mentioned in my original posting, the starting cell of my formula is in Cell C1
My formula joins the cell A1 & B1 in Cell C1
But at every re-calculate of the sheet the value in A1 & B1 gets changed. So accordingly in Cell C1 it get updated. The numerical part is 3 maximum 3 digit length plus % symbol which must be with bigger font and the text part length varies every time from 6 to 9 characters.