Days in office

Discussion in 'Software Q&A' started by ask_livewire, Oct 19, 2006.

Thread Status:
Not open for further replies.
  1. ask_livewire

    ask_livewire New Member

    Joined:
    Aug 13, 2006
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    MUMBAI
    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.
     
  2. mod-the-pc

    mod-the-pc Back to School Mr. Bean !

    Joined:
    Apr 1, 2004
    Messages:
    344
    Likes Received:
    5
    Trophy Points:
    18
    Location:
    Chennai
    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
     
Thread Status:
Not open for further replies.

Share This Page