Is it possible to have text appended to a value entered in a cell that is
dynamic. For example, I know that using the custom number format 0.0" lbs"
would give me 4.0 lbs when entering the value 4 into the cell. Is there a
way to have the text "lbs" be dynamic based on an input elsewhere in the
spreadsheet?

Thanks.

--
Cordell