How do I set up a custom cell format category?

[slk]

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

 

[Gord Dibben]

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

 

[slk]

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.

 

[Fred Smith]

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?

 

[Gord Dibben]

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

 

[Chris]

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

 

[Chris]

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

 

[JE McGimpsey]

One way:

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