how would I put the results of a formula in bold print...

T

traybuddy

the formula that I am using is...

=TEXT((Q9-E1),"0.00")&" hrs"

I would liketo have the numeric answer show up in bold print...
Help on this would be greatly appreciated!
 
G

Gary''s Student

1. copy the cell containing the formula
2. in an un-used cell paste special as value
3. click on the copy
4. in the formula bar highlight the area and format as bold
 
P

Peo Sjoblom

Not possible with any functions, btw you can use a custom format getting the
same result

0.00 "hrs"

will display the same,

Regards,

Peo Sjoblom
 
R

Ron Rosenfeld

the formula that I am using is...

=TEXT((Q9-E1),"0.00")&" hrs"

I would liketo have the numeric answer show up in bold print...
Help on this would be greatly appreciated!
Click to expand...

If you mean that you would like the numeric part to be bold, and the "hrs" to
be in a normal font, that is only possible with actual text strings, and not
with the results of formulas.

In other words, if your cell contained the string "0.00 hrs" it is possible to
have the 0.00 in bold and the hrs in a normal font.

This can be done either manually, or by using a VBA macro (Sub).

Is this what you want?


--ron
 
Top