Apply Number, Date, and Time Formats to Cells

Apply number formats

1.   Select a cell or range of cells containing numerical values that you want to format

2.   From the Ribbon, click Home tab ð Number ð select desired number formatting options

  • Accounting number format
  • Percent style 
  • Commas style
  • Increase decimal
  • Decrease decimal

Apply date formats

1.   Select a cell or range of cells containing text or numerical values that you want to format

2.   From the Ribbon, click Home tab go to Number group and click the list box down arrow and choose Custom

3.   In the Format Cells dialog box, under Category box, choose Date and select a desired format style

Apply time formats

1.   Select a cell or range of cells containimg text or numerical values that you want to format

2.   From the Ribbon, click Home tab, go to Number group and click the list box down arrow and choose Custom

 

3.   In the Format Cells dialog box, under Category box, choose Time and select a desired format style

TIP        Under Category box in the Format Cells dialog box, select Special to find other cell format styles such as Zip Code, Phone Number, and Social Security Number