Custom Format ... (#,##0.0_"lbs"@
Using the "&" symbol in the cell will add on to the value.
For instance: let's say cell A1 is 2, and B1 is 4. In cell C1 you
could say =sum(A1:B1)&" lbs" and it would show "6 lbs" in cell C1.
Notice the space right after the 1st quote mark, that's so it will
show a space in cell C1.
hope this helps
dk
|