Select a cell or a range. Click the Home tab. Click the Number Dialog Box Launcher. Click to select a category. Select the options. Preview your selections in the Sample box. Click OK. Check the result