EXCEL / Unit Conversion Formula Helper

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 type

Enter 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.4

Excel 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

With 25.4 in A1, =CONVERT(A1,"mm","in") returns 1. The mass-pound code used by CONVERT is lbm. The reverse direction works the same way. To turn 150 psi in A1 into bar use =A1*6894.757293168/100000 (about 10.342 bar); to turn 350 °F into °C use =(A1-32)*5/9 or =CONVERT(A1,"F","C") (about 176.667 °C).

How to use

  1. Choose mm→inch, m→ft, kg→lb, bar→psi or °C→°F in the required direction.
  2. Enter a number without a unit suffix in worksheet cell A1 and paste the formula into another cell such as B1.
  3. 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").

KEEP WORKING