The only way to make this change automatically would be to use a
Worksheet_Change event macro. The following routine searches for the 1st space
and makes everything to the left of that space bold. That said, if I type text
in the cell, like 23 cents $US, it works. But with 0.23 in G1, it doesn't work
with your formula.


Private Sub Worksheet_Change(ByVal Target As Range)
Dim Txt As String
Dim i As Long

Txt = Target.Text
i = InStr(Txt, " ")
Target.Characters(1, i - 1).Font.Bold = True

End Sub


On Wed, 20 Oct 2004 03:51:33 GMT, (Roger Bedford) wrote:

I would like to create the information below where the TEXT function result
is
bold and the latter text is a normal font; see below. One person in the
Excel
Function Newsgroup suggested that this could be done using Excel Programming.
=TEXT(G16*100,"00")&" cents $US"

Any sugestions will be much appreciated.

Roger