S
spreadsheetlady
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
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