On May 20, 8:24*pm, dksaluki wrote:
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

Thanks for the reply, but the values are direct entries. I was trying
to create a custom format assigned to the cell or column so that any
value entered has 'lbs' appended.