Formatting Cells to show Ft and Inch

[bamaisgreat]

I was wondering if someone knew a formula or how to format cells to show foot and inch as a reference? Example: 549.75 (45'9 3/4")

 

[Special-K99]

=INT(A1)&"' "&TEXT(12*(A1-INT(A1)),"# #/#")&CHAR(34)

Not my solution

 

[bamaisgreat]

ok thanks. Is there possibly some vba code that will do this? I would like for the cell to be formatted like that.

 

[Special-K99]

Am no VBA expert so I dont have a VBA solution.

 

[Dave Patton]

Excel 2010
	A	B
2	549.75	45' 9 3/4"
3	549.75	45' 9 3/4"
4
5b

Cell Formulas
Range	Formula
B2	=INT(A2/12)&"' "&TEXT(MOD(A1/12,1)*12,"# #/#")&CHAR(34)
B3	=INT(A3/12)&"' "&TEXT(MOD(A2/12,1)*12,"# #/#")&""""