Bold/Underline in formula

[mate]

I have the following:

="with effect from November 2003 to the sum of £" &ROUND(E33,2) &"."

I need the 'Nov 03' and the result of '&round' to be bold and
underlined - can this be done?

TIA

 

[Tushar Mehta]

I don't believe there is any way to change the formatting of a part of a
string that is the result of a formula.

You could break the result into multiple cells. Put the piece before
the month name in one cell, the name of the month into the next cell,
the piece between the month and the ROUND function in the next cell, and
the ROUND function itself in a fourth cell. Now, format the 2nd and 4th
cells as desired.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office

 

[GB]

Maybe this will help?:

ActiveCell.Characters(Start:=5, Length:=4).Font.FontStyle = "Bold"

Geoff