Text Function with Different Formatting for Number

[Guest]

I'm trying to use a text function where I reference a number from another
cell but I need the text part to be bold and the number not to be bold. This
is the formula I'm using right now:

="Sales: "&TEXT(A16,"$#,##0_);($#,##0)")

Unfortunately, excel won't let me just make the text bold without making the
number bold. Anyone have any suggestions? Thanks

 

[Earl Kiosterud]

M,

I think a macro could do this, since it's really a string you're going to
wind up with. But if you can put the Sales: part in a separate cell, life
will be much easier anyway. then you just make the number cell bold.
Normally, labels, like Sales: are not kept with numbers. Most Excel
functionality will not be available with that -- it's not a number, it's
text.