USING TEXT AND NUMBERS IN SAME CELL
 

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.

USING TEXT AND NUMBERS IN SAME CELL
 

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)&" lbs " & 16*(A1-INT(A1))&" oz"
and you will see what you want.
__________________________________________________ _____
Gary's Student


"Model-man" wrote:

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.

USING TEXT AND NUMBERS IN SAME CELL
 

You are very welcome
--
Gary''s Student


"Model-man" wrote:

Hi
Thanks for that.

Greg

"Gary''s Student" wrote:

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)&" lbs " & 16*(A1-INT(A1))&" oz"
and you will see what you want.
__________________________________________________ _____
Gary's Student


"Model-man" wrote:

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.

USING TEXT AND NUMBERS IN SAME CELL
 

Hi
Thanks for that.

Greg

"Gary''s Student" wrote:

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)&" lbs " & 16*(A1-INT(A1))&" oz"
and you will see what you want.
__________________________________________________ _____
Gary's Student


"Model-man" wrote:

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.