Custom number formatting in Excel is easy!

Easy-Excel_3_1Excel has a lot of built-in number formats such as $100.00 or ¥100,00. But what if you want something that is not in the standard menu, like 100 km/h or 14 stone?

If you type “14 stone” 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.