Adding formatting to inline formula..

  • Thread starter Thread starter GHB
  • Start date Start date
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
 
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.
 
Hi Don,

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

Thanks a lot,
-GHB
 
Back
Top