text and formulas in the same cell
 

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

text and formulas in the same cell
 

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.

"barkingmad" wrote in message
...
can I enter text as part of an excel formula, eg: xxx boxes