
Millimetres and inches measure the same thing, length, but they belong to different systems. Millimetres are metric, inches are imperial, and one inch is exactly 25.4 millimetres. If your data arrives in millimetres and your report, your customer, or your drawing needs inches, Excel can convert the whole list for you in seconds.
Excel has a built-in CONVERT function that changes one unit into another, including millimetres to inches. You can also do the conversion with simple division, by dividing the millimetre value by 25.4. Both methods work, and this guide shows you both, along with how to convert a whole column at once, round the result, and format it neatly.
Before You Start
Open the workbook that holds your measurements, or start a new blank workbook to practise in. Put your millimetre values in one column, with a heading such as Length mm at the top. Keeping the values in a single column makes it easy to convert the whole list with one formula and the fill handle.
Check that your values are stored as numbers, not as text. A value stored as text looks the same on screen, but Excel cannot calculate with it, and the CONVERT function will return an error. If a cell has a small green triangle in the corner, or the number sits on the left of the cell, it may be stored as text. Select the cells, click the warning icon, and choose Convert to Number.
Remember the key fact for this whole guide: one inch equals 25.4 millimetres, exactly. That means you divide a millimetre value by 25.4 to get inches, and you multiply an inch value by 25.4 to get millimetres. Every formula in this guide is built on that one number.
Decide where the answers will go. Click the empty column next to your millimetre values and give it a heading such as Length in. The converted values will appear in that column, and your original millimetre values will stay untouched in their own column. Keeping the original data is good practice, because you can always check your work later.
You do not need any add-ins for the CONVERT function in modern Excel. The CONVERT function is built into Excel for Microsoft 365, Excel 2021, Excel 2019, and Excel for the web. In very old versions of Excel, the CONVERT function was part of the Analysis ToolPak add-in, but that has not been needed for many years.
Step 1: Convert millimetres to inches with the CONVERT function.
The CONVERT function is the cleanest way to change units in Excel. It takes three parts: the number to convert, the unit it is in now, and the unit you want. The unit codes go in quotation marks. For millimetres, the code is "mm", and for inches, the code is "in".
Click the empty cell next to your first millimetre value, for example cell B2 if your first value is in A2. Type the formula =CONVERT(A2,"mm","in") and press Enter. If A2 holds 25.4, the result is 1, because 25.4 millimetres is exactly one inch. If A2 holds 50.8, the result is 2, because 50.8 millimetres is exactly two inches.
The CONVERT function needs the value in millimetres and returns inches, so make sure the first code is "mm" and the second code is "in". If you swap them by mistake, Excel will convert inches to millimetres instead, and your answers will be 25.4 times too large. If a result looks far too big, check the order of the two codes first.
You can also type a number directly into the function, such as =CONVERT(100,"mm","in"). This gives 3.93700787401575, which is 100 divided by 25.4. Typing the number directly is fine for a one-off check, but pointing at a cell is better in a real worksheet, because the formula updates if the value changes.
The CONVERT function is case sensitive in some versions of Excel, so use lowercase "mm" and "in" exactly as shown. Uppercase codes such as "MM" may return a #N/A error. If you see that error, check the spelling and the case of the unit codes.

Step 2: Convert with simple division by 25.4.
If you prefer a formula you can read at a glance, divide by 25.4. Click the empty cell next to your first value and type =A2/25.4, where A2 is the cell holding the millimetre value. Press Enter and the answer appears. A value of 127 millimetres gives 5 inches, because 127 divided by 25.4 is exactly 5.
This method gives the same answer as the CONVERT function, because the CONVERT function divides by 25.4 behind the scenes. The difference is only in how the formula looks. Division is easier to understand if someone else reads your worksheet, while CONVERT makes the units explicit in the formula itself.
You can also write the divisor as a cell reference instead of typing 25.4 into every formula. Put 25.4 in a cell, for example Z1, and write the formula as =A2/$Z$1. The dollar signs lock the reference to Z1, so the formula still points at Z1 when you copy it down the column. This is a tidy way to work if the conversion factor might change, or if you want it visible on the sheet.
One small warning: do not round the conversion factor. One inch is exactly 25.4 millimetres, not 25 or 25.5. Using a rounded factor gives answers that drift further from the truth as the numbers get bigger. A length of 2540 millimetres is exactly 100 inches with 25.4, but 101.6 inches if you wrongly divide by 25.
Step 3: Convert a whole column at once with the fill handle.
Converting one cell is useful, but most worksheets hold a whole list of measurements. The fill handle copies your formula down the column in seconds. First, write the formula in the top cell of your answer column, such as =CONVERT(A2,"mm","in") in cell B2.
Move your mouse to the bottom right corner of cell B2. The pointer changes into a small black cross, which is the fill handle. Double click on the fill handle, and Excel copies the formula down as far as your data goes in the next column. Each new formula points at the next row, so B3 converts A3, B4 converts A4, and so on.
If double clicking does not fill the whole column, drag the fill handle down by hand. Click and hold the small black cross, drag down to the last row of your data, and release. The formulas fill in as you drag, and each one updates to its own row.
You can also select the whole answer column first, type the formula, and press Ctrl and Enter together. Excel fills the formula into every selected cell at once, adjusting the row for each one. This is the fastest method when your list has hundreds of rows.
Check a few results by hand after filling. Pick a value you know, such as 25.4 millimetres, and confirm the answer beside it says 1. Pick a large value and confirm the answer looks sensible. A quick spot check catches a formula that was copied to the wrong column.
Related: how to get the sum of a column in Excel
Step 4: Round the result with the ROUND function.
Dividing by 25.4 often gives a long decimal, such as 3.93700787401575 for 100 millimetres. That level of precision is rarely useful, and it makes a report hard to read. The ROUND function trims the answer to the number of decimal places you want.
To round to two decimal places, wrap your conversion in ROUND, like this: =ROUND(CONVERT(A2,"mm","in"),2). The number 2 tells Excel to keep two digits after the decimal point. A value of 100 millimetres becomes 3.94 inches, which is neat and easy to read.
The same idea works with the division method: =ROUND(A2/25.4,2) gives the same rounded answer. Change the 2 to 0 to round to a whole number, so 100 millimetres becomes 4 inches. Change it to 1 for one decimal place, so 100 millimetres becomes 3.9 inches.
Choose the number of decimal places to suit your work. Two decimal places is right for most everyday measurements, such as a product size or a piece of furniture. Three decimal places suits engineering work, where a small difference matters. Whole numbers suit rough estimates, such as the length of a room.
Remember that ROUND changes the value in the cell, not just how it looks. If you round to two decimal places and then use that cell in another calculation, the other calculation uses the rounded value. If you need full precision for later maths, keep the unrounded value in one column and round only the column you display.
Step 5: Format the results so they read as inches.
A bare number such as 3.94 does not say which unit it is in. You can format the cells so they show the inch mark, or a label, without changing the value underneath. Select the cells with your answers, right click, and choose Format Cells. Then choose Custom in the list on the left.
In the Type box, type 0.00" in and click OK. The quotation marks around in tell Excel to show the text in after the number. Your cells will now show 3.94 in, while the value in the cell is still the plain number 3.94. That means you can still use the cell in other calculations, because the label is only part of the display.
You can also use the double quote mark for inches, which is the symbol many drawings use. The custom format 0.00" is the Type box entry for that, where the backslash stops Excel from treating the quote as the end of the format. The cell then shows 3.94" instead of 3.94 in. Both formats are correct, so use whichever your readers expect.
If you only want to control the decimals, use the Number format instead of Custom. Select the cells, go to the Home tab, and click the Increase Decimal or Decrease Decimal button in the Number group. Each click adds or removes one decimal place from the display. This changes how the number looks, but the full value stays in the cell, unlike ROUND, which changes the value itself.
A simple alternative is to put the unit in the column heading, such as Length in, and leave the numbers plain. This is the cleanest option when the whole column shares one unit. It also keeps the numbers easy to copy into another program, because there is no extra text attached to them.
Step 6: Convert inches back to millimetres.
Sometimes the conversion runs the other way, and you need inches turned into millimetres. The CONVERT function handles that too, by swapping the two unit codes. If your inch value is in A2, the formula is =CONVERT(A2,"in","mm"). An inch value of 1 gives 25.4, and an inch value of 5 gives 127.
With the division method, going the other way means multiplying instead of dividing. The formula is =A2*25.4, where A2 holds the inch value. A value of 2 inches gives 50.8 millimetres. Multiplying by 25.4 is the exact reverse of dividing by 25.4, so the two directions always agree.
You can also build a small conversion table with both directions side by side. Put millimetres in column A, inches in column B with =CONVERT(A2,"mm","in"), and a check column in C with =CONVERT(B2,"in","mm"). Column C should match column A exactly. If it does not, one of your formulas has a mistake, and the check column will show you where.
This two-way check is useful when you receive data in mixed units. Convert everything to one unit first, then work only in that unit for the rest of the sheet. Mixing millimetres and inches in the same column is the most common cause of wrong answers in measurement worksheets.
Step 7: Use CONVERT for other units in the same worksheet.
The CONVERT function is not limited to millimetres and inches. It knows many units, and the same pattern works for all of them. The unit codes are short: "cm" for centimetres, "m" for metres, "ft" for feet, "yd" for yards, "km" for kilometres, and "mi" for miles.
To change centimetres to inches, use =CONVERT(A2,"cm","in"). To change millimetres to feet, use =CONVERT(A2,"mm","ft"). To change metres to yards, use =CONVERT(A2,"m","yd"). The structure never changes: value first, then the unit it is in now, then the unit you want.
You can even convert between units that are not lengths, such as weight or temperature, with the same function. For weight, "g" is grams, "kg" is kilograms, and "lbm" is pounds. For temperature, "C" is Celsius and "F" is Fahrenheit, so =CONVERT(100,"C","F") gives 212. The function knows which units belong together, and it returns a #N/A error if you try to convert between different kinds of units, such as millimetres to grams.
A handy trick is to put the unit codes in cells and point the formula at them. For example, put "mm" in cell D1 and "in" in cell E1, then write =CONVERT(A2,$D$1,$E$1). Change the codes in D1 and E1, and the whole column converts to different units at once. This turns a fixed formula into a small conversion tool.

Tips for Showing mm in Inches in Excel
Keep the original millimetre values in their own column and put the converted inches in a new column. Never type over the original data with converted values. If you find a mistake later, the originals are still there to work from, and you can rebuild the answers in a moment.
Add a heading that names the unit, such as Length in, above your answer column. A reader should never have to guess whether a number is in millimetres or inches. A clear heading also stops the most common error in shared worksheets, which is someone reading a millimetre column as if it were inches.
Use Paste Special Values if you need to send the converted numbers to someone without the formulas. Select the answer column, copy it, right click where you want the plain numbers, and choose Paste Special, then Values. The numbers stay, the formulas go, and the file is safe to share with someone who might sort or edit it.
Watch out for millimetres written with the unit attached, such as "25.4 mm" typed into a cell. Excel treats that as text, not a number, and the CONVERT function will return a #VALUE! error. Strip the unit out of the cell and put it in the heading instead, so the cell holds only the number 25.4.
If your measurements come from a drawing or a supplier file, check whether the values are already in inches before converting. Converting twice, once by accident and once on purpose, gives answers 25.4 times too small. A quick sanity check, such as confirming that 25.4 millimetres gives 1 inch, catches this at once.
Troubleshooting
I typed =CONVERT(A2,"mm","in") but I get a #N/A error. What is wrong?
The #N/A error usually means the unit codes are wrong. Check that they are lowercase "mm" and "in", with no extra spaces, and that both codes are inside quotation marks. The error also appears if you try to convert between units of different types, such as length to weight.
Why does my CONVERT formula give a #VALUE! error?
The #VALUE! error means the value you are converting is not a number. It may be text, or it may be a number with the unit typed into the same cell, such as "25.4 mm". Remove the text and keep only the number in the cell.
My answers are 25.4 times too big. What happened?
You probably converted in the wrong direction, turning inches into millimetres instead of millimetres into inches. Check the order of the unit codes. The first code should be "mm" and the second should be "in" when you want inches as the answer.
Why does my answer show so many decimal places?
Dividing by 25.4 often gives a long decimal. Wrap the formula in ROUND, such as =ROUND(CONVERT(A2,"mm","in"),2), to keep two decimal places. You can also use the Decrease Decimal button on the Home tab to change only the display.
The fill handle did not copy my formula down. What should I do?
Make sure there are values in the column next to the formula, because double clicking the fill handle stops at the first blank cell. Drag the fill handle down by hand instead, or select the whole range, type the formula, and press Ctrl and Enter together.
Can I convert a value that is in feet and inches, such as 5 feet 6 inches?
Not in one step, because the value is two numbers in one cell. Split it first, with feet in one column and inches in another, then convert with =(A2*12+B2)*25.4 to get millimetres, or divide the total inches by 25.4 to go the other way.
Related: how to combine two text columns in Excel
Related: how to insert a drop down list in Excel
Frequently Asked Questions
How many millimetres are in one inch?
Exactly 25.4 millimetres. This is an exact definition, not an approximation, so dividing a millimetre value by 25.4 gives an exact inch value.
What is the formula to convert mm to inches in Excel?
Use =CONVERT(A2,"mm","in"), where A2 holds the millimetre value. The simpler alternative is =A2/25.4. Both give the same answer, and you can test either one with =CONVERT(25.4,"mm","in"), which returns 1.
Can I convert mm to inches without the CONVERT function?
Yes, divide the millimetre value by 25.4. The formula =A2/25.4 works in every version of Excel, including very old ones, and it needs no special function at all.
How do I show the result with the inch symbol?
Use a custom number format. Select the cells, open Format Cells, choose Custom, and type 0.00" in as the format. The cells will show the number followed by in, while the value underneath stays a plain number you can calculate with.
How do I convert a whole column of mm values to inches?
Write the formula once in the top cell, such as =CONVERT(A2,"mm","in"), then double click the fill handle in the bottom right corner of that cell. Excel copies the formula down the whole column, adjusting the row for each value.
Does the CONVERT function work in Excel for the web?
Yes, CONVERT works in Excel for the web, and so does the division method. The steps are the same as in the desktop version of Excel.
What unit codes does CONVERT use for length?
The common length codes are "mm" for millimetres, "cm" for centimetres, "m" for metres, "km" for kilometres, "in" for inches, "ft" for feet, "yd" for yards, and "mi" for miles. Use lowercase codes exactly as shown.
Why is my rounded answer different from the exact answer?
Rounding to two decimal places gives a slightly different value from the full precision result. For 100 millimetres, the exact answer is 3.93700787401575 inches, and the rounded answer is 3.94 inches. The difference is tiny, but it is real, so keep the full precision in a hidden column if later calculations need it.
Closing
Showing millimetres as inches in Excel comes down to one number: 25.4. Divide by it, or let the CONVERT function do it for you with =CONVERT(value,"mm","in"). Then copy the formula down the column, round the result to a sensible number of decimals, and label the column so nobody mistakes inches for millimetres.
Keep your original millimetre values in their own column, and check a known value, such as 25.4 millimetres giving exactly 1 inch, before you trust the whole list. With that one check done, your conversions will be right every time, whether you have five measurements or five thousand.