Excel has a few built-in number formats such as $100.00 or ¥100,00. But what if you want to add another measurement unit to the number format, such as lbs, stone, kg, km/h, ft, acre or oz?

If you type “169 lbs” in the cell, Excel will interpret it as text, and you won’t be able to do any calculations. We need to find another way.