I am trying to append "lbs" to the value in the cell, but this does
not seem to work.

Any help is appreciated.

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

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.

....and actually, you should be able to set the format like you had
specifically asked (!) in the format cells options. This was the
number format I used: #,##0.00" lbs" and it showed 375.75 lbs in
the cell for example. so again, notice the space.

On May 20, 8:34*pm, dksaluki wrote:
...and actually, you should be able to set the format like you had
specifically asked (!) in the format cells options. *This was the
number format I used: #,##0.00" lbs" * *and it showed 375.75 lbs * in
the cell for example. *so again, notice the space.

Thanks for the help. If you read the help it does not seem that
simple.