• CONTEST ALERT - Experience the power of DDR5 memory with Kingston Click for details

Days in office

Status
Not open for further replies.

ask_livewire

Right off the assembly line
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

Back to School Mr. Bean !
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
 
Status
Not open for further replies.
Top Bottom