Thread
:
format number in feet and inches
View Single Post
#
2
Jason Morin
Posts: n/a
Try:
=INT(A1)&"'-"&ROUND(MOD(A1,1)*12,0)&""""
HTH
Jason
Atlanta, GA
-----Original Message-----
Id there a way to format a number to feet and inches,
i.e 6.25 to display as
6' 3"??
.
Reply With Quote