# How to Convert Inches to Feet and Inches in Excel

Converting inches to feet and inches in Excel takes one formula built from two functions. Divide the total inches by 12 and round down to get whole feet, then use MOD to get the leftover inches. Join both parts with text labels so the result reads like "5 ft 5 in".

## Quick Answer

- Whole feet: `=INT(B2/12)` divides total inches by 12 and drops the decimal.
- Remaining inches: `=MOD(B2,12)` returns what is left after removing whole feet.
- Combined result: `=INT(B2/12)&" ft "&MOD(B2,12)&" in"` returns a text label such as `5 ft 5 in`.
- The ampersand joins the numbers and labels into one string, so the output is text, not a number.
- Copy the formula down the column to convert every row at once.

## Before You Start

You need one column of total inches with no units typed into the cell. If a cell contains `65 in` as text, Excel cannot divide it, so keep the raw number in its own column and put the label in the result column.

The two functions do the heavy lifting. `INT` rounds a number down to the nearest integer, which is exactly what you want when counting whole feet. `MOD` returns the remainder after division, which is the inches left over once the feet are removed. Together they split one number into two parts without any rounding errors.

One detail matters for correctness. `INT` and `MOD` behave differently from plain rounding. If you used `ROUND` instead of `INT`, a height of 65 inches would still give 5 feet, but a value like 66.5 would round up to 6 feet, so the label would read 6 ft 6.5 in, which is a foot too much. Stick with `INT` for the feet and `MOD` for the inches.

If your inches are stored as text, convert them first with a division formula in Excel, which turns text numbers into real values you can calculate with.

## Step by Step

1. Put your total inches in a column, for example column B, with a header in B1.
2. Click the first result cell, such as C2.
3. Type the formula `=INT(B2/12)&" ft "&MOD(B2,12)&" in"` and press Enter.
4. Check that the cell shows a label like `5 ft 5 in`.
5. Select C2, grab the fill handle, and drag down to fill the rest of the column.

The parentheses around `B2/12` matter. If you write `INT(B2)/12` instead, Excel applies `INT` to B2 first and then divides by 12, so the result is a decimal, not whole feet [1].

## Worked Example

The table below converts a small class roster of heights recorded in total inches. Column B holds the raw inches and column C holds the formula result.

| | A | B | C |
|---|---|---|---|
| **1** | Student | Height (in) | Feet & Inches |
| **2** | Ana | 65 | `=INT(B2/12)&" ft "&MOD(B2,12)&" in"` -> displays 5 ft 5 in |
| **3** | Ben | 70 | `=INT(B3/12)&" ft "&MOD(B3,12)&" in"` -> displays 5 ft 10 in |
| **4** | Cara | 73 | `=INT(B4/12)&" ft "&MOD(B4,12)&" in"` -> displays 6 ft 1 in |
| **5** | Dan | 60 | `=INT(B5/12)&" ft "&MOD(B5,12)&" in"` -> displays 5 ft 0 in |
| **6** | Eve | 68 | `=INT(B6/12)&" ft "&MOD(B6,12)&" in"` -> displays 5 ft 8 in |

The formula in column C converts each height in inches to feet and remaining inches.

Walking through Ana's row: `65/12` is about 5.42, and `INT` drops that to 5 feet. `MOD(65,12)` returns 5, the inches left over. The ampersand joins `5`, the label ` ft `, `5`, and the label ` in` into the string `5 ft 5 in`.

Dan's row shows why the remainder matters. `60/12` is exactly 5 with no leftover, so `MOD(60,12)` returns 0 and the cell reads `5 ft 0 in`. That is correct, and it is the case people most often get wrong when they round instead of using MOD.

## Other Ways to Do It

If you want the feet and inches in separate columns, use two formulas. Put `=INT(B2/12)` in one column for feet and `=MOD(B2,12)` in the next for inches. This keeps both values as numbers, so you can sort, chart, or average them. The combined text version cannot be summed.

For a decimal feet value, use `=B2/12`. A height of 65 inches returns 5.4167 feet. That is useful for calculations but harder to read, so many people keep a decimal column for math and a text column for display.

If you need the result as a real time-like value, Excel's `CONVERT` function handles unit conversions, but it returns a decimal, not a feet-and-inches label. The same split-and-join pattern used here also works for time, as shown in converting decimal hours to hours and minutes in Excel.

## Troubleshooting

If the result shows a decimal like `5.416666667`, you forgot the `INT` wrapper or the parentheses around the division. Check that the formula reads `INT(B2/12)` and not `INT(B2)/12`.

If you see `#VALUE!`, the inches cell likely contains text. Look for stray spaces or unit labels typed into the cell and remove them.

If the output shows `5 ft 5` with no `in`, the closing label is missing from the formula. Every text segment needs its own quotes.

If the feet count is one too high (for example 66 inches shows `6 ft 6 in`), you used `ROUND` or `ROUNDUP` instead of `INT`. Rounding can push the feet count up while `MOD` still returns the same remainder, so the two parts no longer add up to the original inches.

If the formula copies down but every row shows the same value, the references are locked. Remove the dollar signs so `B2` becomes `B3`, `B4`, and so on.

## Common Mistakes

- Using `ROUND` instead of `INT` for the feet. Rounding can push a value up a foot, so the feet and the remainder no longer add up to the original inches. Use `INT` so the feet count always rounds down.
- Forgetting the parentheses around `B2/12`. Without them the division applies to the wrong part of the expression. Wrap the division before passing it to `INT`.
- Typing units into the inches cell. A cell holding `65 in` is text and returns `#VALUE!`. Keep the number bare and add labels only in the result formula.
- Using a minus sign or slash instead of the ampersand. The `&` operator joins text. A `-` would try to subtract and fail.
- Leaving out the spaces inside the labels. `"ft"` and `"in"` run into the numbers. Write `" ft "` and `" in"` with spaces so the output stays readable.
- Expecting the result to sort or calculate. The joined string is text. Keep a numeric column if you need to do math on the values.

## Limitations

The combined formula returns text, so you cannot average, sum, or chart the results directly. If you need those operations, keep the feet and inches in separate numeric columns and build the label only for display. Text results also sort alphabetically, which means `10 ft 2 in` can appear before `2 ft 3 in` in a sorted list.

The method assumes whole inches. If your source data has fractional inches, `MOD` returns a decimal and the label can read `5 ft 5.5 in`. That may be fine, but if you want clean whole inches you need to decide how to round the remainder first, and that rounding choice changes the feet value in edge cases.

## Frequently Asked Questions

### What is the formula to convert inches to feet and inches in Excel?

Use `=INT(A1/12)&" ft "&MOD(A1,12)&" in"`, where A1 holds the total inches. `INT(A1/12)` gives the whole feet and `MOD(A1,12)` gives the remaining inches. The ampersands join the numbers with the text labels.

### Why does my formula show a decimal instead of feet and inches?

You are likely missing the `INT` function or the parentheses around the division. `=A1/12` returns a decimal like 5.4167. Wrapping it as `INT(A1/12)` drops the fraction and gives the whole feet count.

### How do I get feet and inches in separate cells?

Put `=INT(A1/12)` in one cell for feet and `=MOD(A1,12)` in the next for inches. Both stay as numbers, so you can sort and calculate with them. This is the better choice when the values feed into other formulas.

### Can I convert inches to feet and inches without a formula?

You can type the result by hand, but that does not scale and invites errors. A formula recalculates automatically when the source inches change. For a single value, dividing by 12 and reading the remainder works, but the formula is faster for any list.

### Does this work for negative numbers or zero?

Zero returns `0 ft 0 in`, which is correct. Negative values behave oddly because `INT` rounds toward negative infinity and `MOD` follows the sign of the divisor, so a negative inch count can produce a surprising remainder. Convert the sign separately if you need to handle negative values.

For related conversions, the same split-and-join logic appears in converting a month to a number in Excel, where you extract one part of a value and label it clearly.

## References

1. [Altman DG, Bland JM (2011). Brackets (parentheses) in formulas. BMJ](https://doi.org/10.1136/bmj.d570)

## Further Reading

- [Broman KW, Woo KH (2018). Data Organization in Spreadsheets. The American Statistician](https://doi.org/10.1080/00031305.2017.1375989)
- [Ziemann M, Eren Y, El-Osta A (2016). Gene name errors are widespread in the scientific literature. Genome Biology](https://doi.org/10.1186/s13059-016-1044-7)
- [Microsoft Support: Excel help and learning](https://support.microsoft.com/en-us/excel)
- [McCullough B, Heiser DA (2008). On the accuracy of statistical procedures in Microsoft Excel 2007. Computational Statistics & Data Analysis](https://doi.org/10.1016/j.csda.2008.03.004)
- [Abeysooriya M, Soria M, Kasu MS et al. (2021). Gene name errors: Lessons not learned. PLOS Computational Biology](https://doi.org/10.1371/journal.pcbi.1008984)

## Related Articles

- [Division Formula in Excel: How to Divide Cells and Columns](/blog/data-analysis/division-formula-in-excel)
- [How to Convert Month to Number in Excel (Step by Step)](/blog/data-analysis/convert-month-to-number-excel)
- [How to Convert Decimal Hours to Hours and Minutes in Excel](/blog/data-analysis/convert-decimal-hours-to-hours-minutes-excel)
- [How to Freeze Rows and Columns in Excel (Step by Step)](/blog/data-analysis/how-to-freeze-panes-in-excel)
- [How to Use XLOOKUP in Excel (Step by Step)](/blog/data-analysis/how-to-use-xlookup-excel)