Try it! Use numeric formats.

  1. Right click the column header and then select Format Cells or select a column and select Home > Number.

  2. The Format Cells dialog box opens with the Number tab selected by default.
    Note: Press Ctrl + 1 to open the Format Cells dialog box.
  3. In Category, select Custom.

  4. In Type, select an existing format or type a new format in the Type box to create one.
  5. Select OK.




Complete and Continue