Part of formula result formating

[gugi129]

I would like to format part of cell, but in that cell is a formula...
e.g. ="sum is: "&SUM(A1:A10)

Result should have format like...
sum is: 10

Any idea, how to do this? Thanks a lot.

 

[VoG]

Sorry, a formula cannot format a cell.

 

[gugi129]

Isn't it possible to do this by some macro or function?

 

[VoG]

Sorry no, a macro would have to replace the formula with its value. A VBA function cannot change the formatting of a cell.