Excel TEXT Function – handy but limited…or is it?
At first glance the Excel TEXT function appears quite limited. Its purpose is to convert numbers to text in a specific/custom format. There are two key points here: The numbers become text. This means you can’t use them in any math type of formulas. On the upside you can format the numbers anyway you want…almost! …