Days in office

ask_livewire · 19-10-2006, 10:14 PM

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 · 19-10-2006, 10:41 PM

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

19-10-2006, 10:14 PM	#1 (permalink)
ask_livewire Right Off the Assembly Line Join Date: Aug 2006 Location: MUMBAI Posts: 3	Days in office 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.

19-10-2006, 10:41 PM	#2 (permalink)
mod-the-pc Back to School Mr. Bean ! Join Date: Apr 2004 Location: Chennai Posts: 343	Re: Days in office 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 __________________ Desktop: P4 2.8E, Intel 865GBF, 512MB Hynix PC3200, Samsung SV1204H 120GB, Samsung SW-248F, Creative Inspire 4400, Samsung 793MB, Compro PVR/FM, WinLIRC Laptop: HP Pavilion dv8210us

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Popular Categories

Popular Articles

Content Categories

Sister Sites

Follow Us

Facebook Channels

Digit Magazine

	Advertisements. Register and be a member of the community to get rid of them.
Advertisement