Monday, May 21, 2012

How to Insert a Date in Microsoft Excel


Excel 2007
1. Right click on the cell and choose 'Format Cells.'
2. Click on the 'Number' tab.
3. Click on 'Date' in the 'Category' list box.
4. Choose the date format by clicking on one of the formats in the 'Type' box. For example, click on '3/14.'
5. Press 'OK.'
Excel 2003
6. Right click on the cell, the click on 'Format Cells.'
7. Left-click on the 'Number' tab.
8. Scroll to the 'Date' field and highlight it.
9. Scroll to the date format you'd like to use in the 'Type' box.
10. Click on 'OK.'

Blogger news