Excel - converting text to numbers

Many times I have wondered how to convert texts displayed as numbers to a true number in Excel, check this tip for a cool solution.