|
Formatting dates in Excel has to be done in a specific way otherwise
you will not be able to use the dates for calculations. Excel has
interesting data formats and the most common is mm/dd/yyyy where you
enter the month in two digits, the day in two digits and the the year
in four digits like 09/01/2009 for '1st September 2009'.
How to format the data type dates in Excel
- Select the cells on the Excel worksheet that you wish to format and enter dates
- Click on Format in the menu bar and select 'Cells...'
- In the Format Cells dialog box, select number and then date from the Category
- Under Type select the format that suits your work
- Under Locale (Location) keep the default English (United States)
- Under Alignment select how you would like your data to be aligned in the Excel cells
- In
the Font section define the font face, size, colour, etc of your choice
and finally click on OK to complete the process as shown in the Excel
training video
|