How do I display numbers as feet AND inches, as in x'x" ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Orision - 25 Jan 2006 00:37 GMT

How do I get cells to display in feet and inches using the x'x" format? For
instance, instead of 16", display 1'4" . or, instead of 2.5', display 2'6"
I've tried to write my own custom number format to no avail, since I can't
figure out how to get a custom format to perform functions.

Reply to this Message

Gary''s Student - 25 Jan 2006 00:55 GMT

=TEXT(INT(A1),"0 '")&TEXT(MOD(A1,1)*12,"-0 \""")

Signature

Gary's Student

> How do I get cells to display in feet and inches using the x'x" format? For
> instance, instead of 16", display 1'4" . or, instead of 2.5', display 2'6"
> I've tried to write my own custom number format to no avail, since I can't
> figure out how to get a custom format to perform functions.

Reply to this Message

Orision - 25 Jan 2006 01:21 GMT

I am trying to figure out how to create a numbr format that keeps the data in
the cell as the number of inches, but displayes it using the method of 12'
5". A number format as in the date. The date stored the value of the cell as
a number, but displays it differently. I would just use a custom number
format of

m'yyyy''

except 1) ECEL assumes 1900 and 2) EXCEL assumes that a numer is the number
of days, so when I would want to increase by 5 inches, I would increase by 5
days, not 5 months, but if it did increase by 5 months then the display would
be what I want it to be.

I know it is possibly for this to happen, since EXCEL can already do it for
the much mroe complicated time measurement system right from seconds to year.
So, inches to feet shouldn't be ALL that diffuclt... maybe I'll actually ahve
to write a VBA... Wow I don't want to do that.

> =TEXT(INT(A1),"0 '")&TEXT(MOD(A1,1)*12,"-0 \""")
>
> > How do I get cells to display in feet and inches using the x'x" format? For
> > instance, instead of 16", display 1'4" . or, instead of 2.5', display 2'6"
> > I've tried to write my own custom number format to no avail, since I can't
> > figure out how to get a custom format to perform functions.

Reply to this Message