Home -> Number ->Format Cells

Format Date and Time

Many companies work with people from around the world. When you select a format that displays the names of the months, it makes it clear whether 2/1/11 is January 2nd or February 1st. Please format this column for date and time.

 

 

3. Try This: Change The Date Format

Select Column A, first.

Go to Home->Number.

The default number format is General. Select: Long Date.

Exam 77-882: Microsoft Excel 2010 Core

3. Formatting Cells and Worksheets

3.6. Create and apply cell styles: Format the Date