frisbeenut
Member
I got the formula from the internet which will convert a given decimal number in feet / inches with fractions and it is somewhat useful.
=INT(MROUND(A1,1/16)/12) & "' -" & TEXT(MOD(MROUND(A1,1/16),12),"# #/##") & """"
(Note: currently configured for 1/16ths)
37.25 will be converted to 3' -1 1/4"
Which is correct.
However, in my opinion it does not convert the number correctly when there are either zero inches or zero feet
37.25 will display as 3' -1/4", which is incorrect. It should be 3'-0 1/4"
Similarly 0.25 will display 0' -1/4". It should be simply 1/4"
Lastly, 6.25 will display as 0'-6 1/4". This might be acceptable but there are times it is better to convert to 6 1/4".
I think it would be best to use a custom VBA function to handle this conversion. It would also be great if the function accepted two parameters, the first to be the number to convert and the second being the fractional accuracy desired, 2, 4, 8, 16 and so on, or a custom accuracy, like thirds. (Maybe two additional T / F parameters to control zero feet and zero inches suppression, but that is not totally necessary, but would be great for all users.)
Any help will be appreciated.
Thanks
=INT(MROUND(A1,1/16)/12) & "' -" & TEXT(MOD(MROUND(A1,1/16),12),"# #/##") & """"
(Note: currently configured for 1/16ths)
37.25 will be converted to 3' -1 1/4"
Which is correct.
However, in my opinion it does not convert the number correctly when there are either zero inches or zero feet
37.25 will display as 3' -1/4", which is incorrect. It should be 3'-0 1/4"
Similarly 0.25 will display 0' -1/4". It should be simply 1/4"
Lastly, 6.25 will display as 0'-6 1/4". This might be acceptable but there are times it is better to convert to 6 1/4".
I think it would be best to use a custom VBA function to handle this conversion. It would also be great if the function accepted two parameters, the first to be the number to convert and the second being the fractional accuracy desired, 2, 4, 8, 16 and so on, or a custom accuracy, like thirds. (Maybe two additional T / F parameters to control zero feet and zero inches suppression, but that is not totally necessary, but would be great for all users.)
Any help will be appreciated.
Thanks