Copy and paste special as value then select the 24.92 and format to bold.

Cannot be done in a formula.


Gord Dibben MS Excel MVP


On Wed, 21 May 2008 08:23:00 -0700, GabrielN
wrote:

Is there a way to bold a nested function? I.E. I have the fuction like below:

="Emerging Markets"& " "&TEXT(BL962,"###.##")

Which ends up being:
Emerging
Markets
24.92

I would like to just bold the 24.92 and nothing else in the cell. Is there
anyway to do this in excel?