To apply a number format to text-formatted numbers: 1. Select the cells with text-formatted numbers. 2. Go to the Home tab, click the Dialog Box Launcher next to Number in the Number group. 3. In the Format Cells dialog box, choose a number format and click OK.