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.