Format text

[Manos]

Dear all

I have a formula where i am taken a text and a number

"euro"& text(a1+b1,"0,00")&

There is anyway that i can make euro to appear BOLD but
not the number?

Thanks in advance
Manos

 

[Frank Kabel]

Hi Manos
this is not possible with formulas. Formulas can only return values but
not formating information. So: no chance even with a user defined
function in VBA

 

[darkangelstorm]

could use conditional formatting
Format it so it's a custom formula w/e the cells are
eg. A1="euro" then define what you want to do with it....

DA

 

[Harlan Grove]

this is not possible with formulas. Formulas can only return values but
not formating information. So: no chance even with a user defined
function in VBA

Well, not with a udf, but it's possible using a Calculate event handler,
ancillary cells and picture links. The Calculate event handler would set copy
the .Text property of the cell containing the formula to the ancillary cell,
then use that cell's .Characters property to format the number portion, then
copy that cell and paste as a picture link on top of the cell containing the
formula. The cell containing the formula would need to have number format ;;;.

This is quite fragile, but it would do what the OP wants. However, if the OP has
never written any VBA, this would be impractical.

 

[Frank Kabel]

...

Well, not with a udf, but it's possible using a Calculate event handler,
ancillary cells and picture links. The Calculate event handler would set copy
the .Text property of the cell containing the formula to the ancillary cell,
then use that cell's .Characters property to format the number portion, then
copy that cell and paste as a picture link on top of the cell containing the
formula. The cell containing the formula would need to have number format ;;;.

This is quite fragile, but it would do what the OP wants. However, if the OP has
never written any VBA, this would be impractical.

Hi Harlan
nice idea but I agree with you this is a little bit fragile and
probably not a 'simple' solution for the OP
Frank