Format cell to convert inches to feet

[Obfuscated]

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.

[davesexcel]

I don't think there is a format, but a calculation?

Please Login or Register  to view this content.

[Obfuscated]

Thanks for replying. I know the calculations and vba to do it, but was hoping someone had stumbled on a cell format.

[yurttas]

.

This might help you.

=CONVERT(600;"in";"ft")

=CONVERT(604;"in";"ft")

And cell custom format:

####,00"'"

.

[yurttas]

.

Repeat...

.

[MrShorty]

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.

[Tony Valko]

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.