Format Numbers and Dates

Format Numbers

  • Select a cell or range(s) needed to be formatted

  • Do one of the following:

    • Go to Home tab > Number group > select appropriate number format to apply to a cell or range(s)

      • Accounting Number Format

      • Percent Style

      • Commas Style

      • Increase Decimal

      • Decrease Decimal

    • Go to Home tab > Number group > click the drop down arrow in General box > select appropriate number format to apply to a cell or range(s)

    • For advanced formatting number, go to Home tab > Number group > click Dialog Box Launcher > do the following in the Format Cells dialog box:

      • Click Number tab

      • Under the Category box, select appropriate number format



Format Dates

  • Select the range need to be formatted

  • Do one of the following:

    • Press CTRL + 1 key

    • Go to Home tab > Number group > click Dialog Box Launcher

  • In the Format Cells dialog box, click Number tab > select any of the following under the Category box:

    • Click Date > under the Type box, select desired format

    • For advanced formatting dates, click Custom > under the Type box. select and edit format style