Adding formatting to inline formula..

[GHB]

Is there a way to merge text and a cell value such that the cell value
has a particulat format.

For example, suppose I want to display the following in a cell:

Less 5% of (contents of another cell) =

I could put something like the following in the cell:
="Less 5% of " &A1 "="

However, is there a way to format the inserted value from A1 as bold or
italics or a particular number format?

TIA,
-GHB

 

[Don Guillett]

Bold,italic etc will not work in a formula but will in just text. In the
formula bar, just highlite the desired and format as desired.

But you can use TEXT (look in help index) to format the number part of a
formula.

 

[GHB]

Hi Don,

I forgot my manners...Your suggestion pointed me in the right direction
and solved my problem.

Thanks a lot,
-GHB

 

[Don Guillett]

glad to help