Step 1: Select the cells that contain the numbers that are stored as text.
Step 2: On the Home tab, in the Number group, click the Dialog Box Launcher Button image next to Number.

Step 3: In the Category box, click the number format that you want to use.
And you are done...