Bold/Underline in formula

  • Thread starter Thread starter mate
  • Start date Start date
M

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
 
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
 
Maybe this will help?:

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

Geoff
 
Back
Top