Ever been frustrated with Microsoft Excel when you have been working with a cell but you want to show the units of the cell such as 5 Kgs, 5 Bags or 4 Punnets but Microsoft Excel keeps turning the cell into text. Well, there is in fact a way of creating a custom format in Microsoft Excel that lets you show the units of the value whilst still keeping the value being treated as a number.

So, how do we do it