text in a cell

R

rob kessler

I have a formula in a cell but I'd like for the word "less" to appear next to
the result of the formula in the cell. Can I do this? I can't figure out
how.
 
G

Gord Dibben

=A1+B1 & "less"

="less" & A1+B1

Or simply format the cell as Custom

="less "#,##0.00


Gord Dibben MS Excel MVP


On Mon, 19 Oct 2009 14:50:01 -0700, rob kessler <rob
 
Top