Convert units in Excel

Excel has two ways to convert a unit, and they answer different questions.

CONVERT

CONVERT is built into Excel. It knows a fixed list of codes, such as kPa and psi. It does not know bar, centipoise or a newton metre. Codes are case-sensitive, and a prefix multiplies the unit as written.

CONVERT unit codes

LAMBDA

A LAMBDA uses the factors from this site, for every unit in a quantity, including the ones CONVERT skips. You can save it as a named function. Microsoft 365, with no VBA.

How to write and save a LAMBDA

This site does not publish an Excel add-in. For API gravity and oilfield rates, see Petroleum Office.

Quantities

LAMBDA library

Google Sheets

Google Sheets has CONVERT and many of the same codes, and it has LAMBDA. Named functions are created under Data > Named functions, not Formulas > Name Manager. A code that works in Excel can return #N/A in Sheets, so try a known value before you rely on it.