Maybe custom formatting is the answer for you:
Example:
FormatCellsNumber
Category: Custom
Type: #,##0" Year End Results"

Will display numeric contents with "Year End Results" appended
Example:
A1: 1234
displays as: 1,234 Year End Results


Is that something you can adapt to suit your situation?

***********
Regards,
Ron


"Eric" wrote:

I need to be able to have text ("year end results") displayed then the answer
from my formula. how do i do this?