text and formulas in the same cell

  • Thread starter Thread starter barkingmad
  • Start date Start date
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.
 
Back
Top