Formatting

Hi Polly,

Hope this helps.

1.Right-click on the cell where the date is.
2.Select Format Cells.
3.When the dialogue box opens select the Number tab.
4.In the Category list to the left select Date.
5.In the Type list to the right select the format closest to what you want. A sample format will show above.
6.In the Category list to the left select Custom. A list of custom formats will show to the right, and the format you selected will show in the Edit Box above.
7.Modify the format in the Edit Box and watch the sample.
8.When you are satisfied click OK.
9.The new format will be applied to the cell and will also be added to the list of custom formats.