LinkBack URL
About LinkBacks
Is there a cell format that will convert inches to feet & inches?
I can do it with vba, but a cell format would be cleaner.
I need to convert 600 inches to 50' 0
or 604 inches to 50' 4
Thanks.
Is there a cell format that will convert inches to feet & inches?
I can do it with vba, but a cell format would be cleaner.
I need to convert 600 inches to 50' 0
or 604 inches to 50' 4
Thanks.
I don't think there is a format, but a calculation?
Formula:
=INT(A1/12)&"' "&TRIM(TEXT(A1-INT(A1/12)*12,"# ???/???"))&""""
Thanks for replying. I know the calculations and vba to do it, but was hoping someone had stumbled on a cell format.
.
This might help you.
=CONVERT(600;"in";"ft")
=CONVERT(604;"in";"ft")
And cell custom format:
####,00"'"
.
.
Repeat...
.
Last edited by yurttas; 01-13-2017 at 11:34 AM.
Available number format codes: https://support.office.com/en-us/art...2-09fab54be7f4
I am not aware of a number format that will display a value in inches as feet inches.
From a fractional feet number, I have used a format code like 0 0/12 to display feet and inches (as a fraction of a foot), but that still requires you to convert your inches to feet, and I suspect many would be less than satistified with the fraction/12.
I would expect that something like davesexcel's text output is going to be the easiest way to get exactly what you are requesting.
Originally Posted by shg
I know you don't want a formula but for anyone else that might...
=INT(A1/12)&"' "&MOD(A1,12)&""""
Assumes the inch value will always be an integer.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks