Dates

Hi Elizabeth,


Thank you for your question.

To create a date format that includes the day, date, full month and year, you will need to create a customised date format. To do this:

- Select the date that you want to format, i.e. 01/01/2011

- Right click the cell, selecting 'Format Cells...' from the menu

- With the 'Number' tab open select 'Custom' from the category list

- Place your cursor in the text field below the heading 'Type:' and delete the contents

- Now type: dddd dd mmmm yyyy

* As you type this format the sample view above will display a preview of the date

* You can replace the spaces in the example above with a hyphen (-), forward slash (/) or any other character.


I hope this resolves your question. If it has, please mark this question as resolved.


If you require further assistance, please reply to this post.


Regards,


Nafeesa

Microsoft Office Specialist Trainer