software

Hi
I am trying to type in something like 21lb 8oz but also use the decimal
version 21.5 in the same cell as a number,so i can use =sum. I do not need to
see the number 21.5, in fact it would be prefferable not to.

Can anyone help.

Since you want to do math on the number and still see it in logical units,
consider using two cells:In A1 put 21.5
in B1 put =INT(A1)amp;quot; lbs quot; amp; 16*(A1-INT(A1))amp;quot; ozquot;
and you will see what you want.
__________________________________________________ _____
Gary's Studentquot;Model-manquot; wrote:

gt; Hi
gt; I am trying to type in something like 21lb 8oz but also use the decimal
gt; version 21.5 in the same cell as a number,so i can use =sum. I do not need to
gt; see the number 21.5, in fact it would be prefferable not to.
gt;
gt; Can anyone help.

You are very welcome
--
Gary''s Studentquot;Model-manquot; wrote:

gt; Hi
gt; Thanks for that.
gt;
gt; Greg
gt;
gt; quot;Gary''s Studentquot; wrote:
gt;
gt; gt; Since you want to do math on the number and still see it in logical units,
gt; gt; consider using two cells:
gt; gt;
gt; gt;
gt; gt; In A1 put 21.5
gt; gt; in B1 put =INT(A1)amp;quot; lbs quot; amp; 16*(A1-INT(A1))amp;quot; ozquot;
gt; gt; and you will see what you want.
gt; gt; __________________________________________________ _____
gt; gt; Gary's Student
gt; gt;
gt; gt;
gt; gt; quot;Model-manquot; wrote:
gt; gt;
gt; gt; gt; Hi
gt; gt; gt; I am trying to type in something like 21lb 8oz but also use the decimal
gt; gt; gt; version 21.5 in the same cell as a number,so i can use =sum. I do not need to
gt; gt; gt; see the number 21.5, in fact it would be prefferable not to.
gt; gt; gt;
gt; gt; gt; Can anyone help.

Hi
Thanks for that.

Greg

quot;Gary''s Studentquot; wrote:

gt; Since you want to do math on the number and still see it in logical units,
gt; consider using two cells:
gt;
gt;
gt; In A1 put 21.5
gt; in B1 put =INT(A1)amp;quot; lbs quot; amp; 16*(A1-INT(A1))amp;quot; ozquot;
gt; and you will see what you want.
gt; __________________________________________________ _____
gt; Gary's Student
gt;
gt;
gt; quot;Model-manquot; wrote:
gt;
gt; gt; Hi
gt; gt; I am trying to type in something like 21lb 8oz but also use the decimal
gt; gt; version 21.5 in the same cell as a number,so i can use =sum. I do not need to
gt; gt; see the number 21.5, in fact it would be prefferable not to.
gt; gt;
gt; gt; Can anyone help.