Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Changing Date format in Excel

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 15-10-2009
Member
 
Join Date: Feb 2009
Posts: 90
Changing Date format in Excel
  

I am using excel 2003 on my windows xp computer. I want to know the procedure to change date format in excel sheet. After entering data it must change automatically to another format.

Reply With Quote
  #2  
Old 15-10-2009
Member
 
Join Date: May 2008
Posts: 4,829
Re: Changing Date format in Excel

Select the cell(s) (where you want to insert data)containing the date(s) > Open the menu "format" and choose "cells" > On the list on the left choose "custom" > It may be that the dates are simply formatted as YYMMDD. In the "type" text field you will see something like m/d/yyyy(you can also select another format) , delete it, and type the following instead: dd-mmm-yy > Click OK.
Reply With Quote
  #3  
Old 15-10-2009
Member
 
Join Date: Dec 2008
Posts: 371
Re: Changing Date format in Excel

First select the cells and go to <Format> <Cells> <Number> tab In the Category window, click on <Date> And see if you can find something that you like in the Type window, Then click OK. Or, if the dates are currently entered as text or numbers, use a formula to convert.
Reply With Quote
  #4  
Old 15-10-2009
Member
 
Join Date: May 2008
Posts: 4,339
Re: Changing Date format in Excel

In Microsoft Excel, when you use the date code, &[Date], to insert the date in the header or footer of a document, the date appears in the default "MM/DD/YY" format. The time code, &[Time], appears in the default "H:MM AM/PM" format. These date and time formats are based on the Date and Time tabs in the Regional Settings Properties dialog box.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Changing Date format in Excel"
Thread Thread Starter Forum Replies Last Post
Disable Excel 2007 Date Auto Format Forrest Ranger MS Office Support 2 09-02-2012 06:36 PM
Excel 2007 impulsively formats whole work book in date format foraman Windows Software 5 29-11-2010 11:14 PM
Changing the date format Uzair Customize Desktop 3 03-04-2009 12:44 PM
Can't change date format in Excel footer Imthyaz K MS Office Support 2 28-01-2007 06:41 AM


All times are GMT +5.5. The time now is 02:24 AM.