| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Format a Nested Function (Bold)
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Format a Nested Function (Bold)
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Format a Nested Function (Bold)
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? Why not put "Emerging Markets" in one cell and the text formula in another? Bill |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add Bold to the custom number format | Excel Discussion (Misc queries) | |||
| Bold format. | Excel Discussion (Misc queries) | |||
| Conditional Sum based on Bold Format | Excel Discussion (Misc queries) | |||
| Condontionally format bold cells | Excel Discussion (Misc queries) | |||
| if/then changing text format to Bold | Excel Worksheet Functions | |||
Linear Mode
