text and formulas in the same cell

[barkingmad]

can I enter text as part of an excel formula, eg: xxx boxes

 

[Fred Smith]

Yes, just put it in quotes. Somthing like:

=a1&" boxes"

You can also set up a custom format to achieve the same thing.

If you want to format the way A1 appears, use something like:

=text(a1,"0.00")&" boxes"

Regards
Fred.