About Us

Michael Peace[_2_]

I have a list of measurements in decimal inches and I want to display them in
feet, inches, and fractions of an inch. I.E. 75.522" would be displayed as
6'-3 1/2"

Is this even possible?

Glenn

Michael Peace wrote:
I have a list of measurements in decimal inches and I want to display them in
feet, inches, and fractions of an inch. I.E. 75.522" would be displayed as
6'-3 1/2"

Is this even possible?

Ron Rosenfeld posted this a while back:

=IF(ABS(A1)=MROUND(ABS(A1),1/16),"","~")&IF(A1<0,"(","")&
IF(INT(ABS(A1/12))=1,INT(ABS(A1/12))&"' ","")&
TRIM(TEXT(MROUND(MOD(ABS(A1),12),1/16),"#-#/##\"""))&
IF(A1<0,")","")

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert inches & display as Feet Inches and Fractions -- BUG FREE	Mark Main	Excel Worksheet Functions	12	November 26th 08 08:50 PM
Formula converts a value to Feet Inches and fractions of an inch	Mark Main	Excel Discussion (Misc queries)	1	October 17th 08 05:06 PM
How do I use feet and inches (including fractions of inches)	MRZ	Excel Worksheet Functions	2	September 18th 08 10:35 PM
Converting from feet, inches and fractions to inches and decimal p	Dee	Setting up and Configuration of Excel	5	September 18th 07 04:18 PM
display number as feet and inch in single cell	covdbrdg	Excel Discussion (Misc queries)	5	September 11th 06 07:58 PM

Menu

About Us