Unit Conversion Formula Helper
Copy arithmetic or Excel CONVERT formulas that convert the value in cell A1 to another engineering unit.
Inputs
Updates as you typeEnter only a number in A1 and paste the formula into another cell such as B1. This page does not read workbook values or results.
Results
Excel 2016 / 2019 / Microsoft 365
=A1/25.4Excel 2016 / 2019 / Microsoft 365
=CONVERT(A1,"mm","in")Overview
Copy arithmetic or Excel CONVERT formulas that convert the value in cell A1 to another engineering unit. Use it to convert a whole column of inch, psi or °F values from a foreign vendor's datasheet, or to bring a material list onto the project's units.
Formula
mm → inch: =A1/25.4 m → ft: =A1/0.3048 kg → lb: =A1/0.45359237 °C → °F: =A1*9/5+32
Example
How to use
- Choose mm→inch, m→ft, kg→lb, bar→psi or °C→°F in the required direction.
- Enter a number without a unit suffix in worksheet cell A1 and paste the formula into another cell such as B1.
- Check a known value such as 25.4 mm→1 inch before filling down. Label the output column with its unit and pressure reference where relevant.
Engineering notes
- CONVERT codes can be case-sensitive. Formula unit codes are not always the same as display abbreviations.
- Adding a unit suffix through cell formatting does not convert the numerical value. Use a formula and label the result column.
- This helper generates formulas; it does not read or evaluate your worksheet. kg→lb converts mass, °C→°F converts actual temperature rather than an interval, and bar→psi preserves the pressure reference.
- For a CONVERT #N/A error, check unit codes, case and measurement types. Excel's regional settings may use a different argument separator.
- Rather than typing the factor into every formula, put it in its own cell (for example 25.4 in B1) and use an absolute reference such as =A2/$B$1; it is easier to review and change.
Frequently asked questions FAQ
Why is there no CONVERT formula for bar to psi?
Microsoft's CONVERT pressure-unit list does not include bar, so this helper uses =A1*100000/6894.757293168. One bar is approximately 14.503774 psi. The formula changes the unit, not the gauge or absolute reference.
Can A1 contain a number and unit, such as 25.4 mm?
Enter the number 25.4 in A1 and put mm in the column heading. A text value containing a unit can cause a calculation error. Formatting a result with an inch suffix does not itself convert its numerical value.
How do I store the result rounded to three decimals?
Wrap it in ROUND, as in =ROUND(A1/25.4,3). Changing only the number format rounds the display while the full value stays and is used in later calculations.
What is the formula for inch back to mm?
=A1*25.4 or =CONVERT(A1,"in","mm"). For lb to kg use =A1*0.45359237 or =CONVERT(A1,"lbm","kg").
Related tools
Excel Text Extract Helper
Suggest fixed-position or delimiter-based Excel formulas from source text and the substring you want to extract.
Open calculatorString Split Helper
Preview text split by a literal delimiter, with TEXTSPLIT for Microsoft 365 and guidance for older Excel versions.
Open calculatorCommon Excel Formula Examples
Explore common text functions using a fixed pipe-tag sample, with each formula and its expected result.
Open calculator