When you use A1 in a formula, it uses the contents of the cell, and ignores
formats. Formats control only the display of that cell, and have no impact
on other formulas. To include formatting in your formula, use the Text
function, as in:
=Text(B1*C1,"#,##0)&" lbs."

Or, use the formula:
=b1*c1
and set a custom format of: #,##0" lbs"

Regards,
Fred

"spreadsheetlady" wrote in
message ...
Hi,
Basic Formula in A1 says: B1*C1. This works.
I have all cells formatted to Number Format with 0 decimal place(s). I
also
have the 1000 separator (,) check box checked.

If I change the same formula in A1 to: B1*C1&" lbs." .....A1 gives
the
right answer but shows a zillion decimal places with it.

Is there a tip anyone could give me on what is happening and a suggestion
for getting rid of the decimal places?

Because of the &" lbs." does Excel maybe think the formula is text? I
don't
know.

Thank-you in advance,
Amy