Days in office

[ask_livewire]

i work in ms office 2000, amd i wanted to know that how can i change the format of my dates so that it appears along with the day. for eg when i would enter 10/19/2006 (October 19, 2006) in a cell in excel, it should display Thursday, 19 October, 2006 or something like that, i am only concerned about the day and the dates, please help me outta this trouble.

[mod-the-pc]

Select the cell(s) you want to format. Choose Format>Cells.
In the Number tab select "Date" from the left pane and the appropriate format from the right