Formatting Data and Content

Formatting Data and Content

Formatting Data

excel-conditional-formatting-data 4

Formatting for date

  1. Select cells B12.
  2. Choose Format > Cells from the menu to open the Format Cells dialog box.

With the Format Cells dialog box open:

  1. Click on the Number Tab (circled in red in the image above).
  2. Select Date in the Category Window.
  3. Select *3/14/2001 in the Type Window.
  • When finished, Click OK at the bottom of the Format Cells dialog box.
Create, Modify, and Position Diagrams and Charts Based on Worksheet Data
Apply and Modify Cell Formats

Get industry recognized certification – Contact us

keyboard_arrow_up