Hi Eric,
What do you mean when you use the term "box", a cell or a text box?
If you mean cell then add the following to the required cell:
= "year end results " & ......

at ...... just type your formula without the "=" since it's already at
the front.

e.g; = "year end results " & SIN(radians(30)) returns "year end result
0.5"

Silly example I know. Also note the space after the word "results".

If you mean text box then:

as above to first get it into a cell, then create your text box, then
while the text box is selected click in the formula bar, type "="
(without speech marks), then select the cell with the text and formula,
then press Enter. You can then format the text box as you like

Ken Johnson