Bolding a function number

[Roger Bedford]

I would like to create text to show '6 dollars' where the 6 originates in
another cell and be able to Bold the number only. I have tried many versions
but so far no luck.

Any help will be greatfully appreciated.

Roger

 

[Frank Kabel]

Hi
not possible with formulas

 

[Paul Corrado]

Roger, there is a custom function called SPELLNUMBER that will do this.

http://support.microsoft.com/default.aspx?scid=kb;en-us;213360

 

[CarlosAntenna]

format > cells > custom > 0 " dollars"

that gets the dollars but not the bold.

Carlos

 

[Roger Bedford]

Hi Frank, thanks for your comment. Do you have any other suggestions to create
text to show '6 dollars' where the 6 originates in another cell and be able to
Bold the number only bearing in mind that I am basically an Excel 5 user just
starting Excel 2002.

Roger

 

[Frank Kabel]

Hi
as said: Not at all possible with formulas. You'll need VBA for this

 

[Roger Bedford]

Hi Frank, would you mind sending me the VBA that would solve my problem if it
is not too much trouble? It would be much appreciated.

Roger

 

[Roger Bedford]

Thanks for all your suggestions. I'll try Excel Programming Newsgroup to see
if anyone can solve this problem there.

Roger

 

[Harlan Grove]

Thanks for all your suggestions. I'll try Excel Programming Newsgroup
to see if anyone can solve this problem there.

....

Try it all you want. If you want the cell to remain a formula, then either
all the text produced by the formula must be bold or none of it may be bold.
All programming could get you is automatically converting the formula into
constant text in which the number could be bold and the rest not, but that
leaves the problem of how to update the cell when the formula's result would
have changed. Trying to handle recalculation via event handlers will prove
to be MUCH MORE TROUBLE than it's worth.