Adding formatting to inline formula..

G

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
 
D

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.
 
G

GHB

Hi Don,

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

Thanks a lot,
-GHB
 
Top