I'm trying to add a column of pounds and ounces.

How is/will your data be entered?

In one cell or two cells? Post the form please.

What do you mean by "add".......SUM?

What do you want the ouput to look like?

123 pounds 14 ounces or?


Gord Dibben MS Excel MVP

On Thu, 24 May 2007 13:32:48 -0700, slk wrote:

I'm trying to add a column of pounds and ounces.

1 lb 14 oz is an example of the type of data. I was referring to adding the
custom cell format, not particularly the column of data.

"Gord Dibben" wrote:

How is/will your data be entered?

In one cell or two cells? Post the form please.

What do you mean by "add".......SUM?

What do you want the ouput to look like?

123 pounds 14 ounces or?


Gord Dibben MS Excel MVP

On Thu, 24 May 2007 13:32:48 -0700, slk wrote:

I'm trying to add a column of pounds and ounces.

You still need to answer the question about where the data is. Are the pounds
and ounces in separate cells? Or, is it in a format like 1.14? Or is the source
data in pounds only? Or ounces only?

--
Regards,
Fred


"slk" wrote in message
...
1 lb 14 oz is an example of the type of data. I was referring to adding the
custom cell format, not particularly the column of data.

"Gord Dibben" wrote:

How is/will your data be entered?

In one cell or two cells? Post the form please.

What do you mean by "add".......SUM?

What do you want the ouput to look like?

123 pounds 14 ounces or?


Gord Dibben MS Excel MVP

On Thu, 24 May 2007 13:32:48 -0700, slk
wrote:

I'm trying to add a column of pounds and ounces.

I assume 1 lb 14 oz is the output style you want.

But where are are you entering the numbers and how?

1.14 in one cell?

120 in A1 and a formula in B1 =A1/16 which returns 7.5 and you want formatted
to 8 lbs 8 oz?


Gord



On Thu, 24 May 2007 16:44:01 -0700, slk wrote:

1 lb 14 oz is an example of the type of data. I was referring to adding the
custom cell format, not particularly the column of data.

"Gord Dibben" wrote:

How is/will your data be entered?

In one cell or two cells? Post the form please.

What do you mean by "add".......SUM?

What do you want the ouput to look like?

123 pounds 14 ounces or?


Gord Dibben MS Excel MVP

On Thu, 24 May 2007 13:32:48 -0700, slk wrote:

I'm trying to add a column of pounds and ounces.

I have a similiar question. My date is in the format of 69 1/8 as a fractional number format. I want to convert it to 4 lb 5 1/8 oz in a single cell but the conversion process can take place in multiple cells, I just want the final "4 lb 5 1/8 oz" as a single cell. I can accomplish this mostly but I end up with 4 lb 5.125 oz and I want the fraction. Any advice.

Thanks

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

I have a similiar question. My date is in the format of 69 1/8 as a fractional number format. I want to convert it to 4 lb 5 1/8 oz in a single cell but the conversion process can take place in multiple cells, I just want the final "4 lb 5 1/8 oz" as a single cell. I can accomplish this mostly but I end up with 4 lb 5.125 oz and I want the fraction. Any advice.

Thanks

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

One way:

=TEXT(INT(A1/16),"0 lb ") & TEXT(MOD(A1/16,1)*16,"0 ?/? oz")

In article , Chris wrote:

I have a similiar question. My date is in the format of 69 1/8 as a
fractional number format. I want to convert it to 4 lb 5 1/8 oz in a single
cell but the conversion process can take place in multiple cells, I just want
the final "4 lb 5 1/8 oz" as a single cell. I can accomplish this mostly but
I end up with 4 lb 5.125 oz and I want the fraction. Any advice.

Thanks

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com