Search : in
By :

How to change the date format in excel 2007

Last answer on Jul 30, 2009 8:27:10 am BST CHRIST, on Jul 30, 2009 8:10:05 am BST 
 Report this message to moderators

Hello,

how I can chnage the format of 15.02.2003 to 2/15/2003 in excel 2007. Give the exact route.

Configuration: Windows XP Internet Explorer 6.0

Best answers for « how to change the date format in excel 2007 » in :
[Excel]changing cell formula to text Show[Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
Verifying date format in PHP ShowVerifying date format in PHP There are several ways to check the format of a date in PHP; the simplest method is to make use regular expressions. To confirm a date format DD/MM/YYYY, where the days and/or month can be given as...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Ask your question Reply

1

 Sri, on Jul 30, 2009 8:27:10 am BST

Select the cell and right click, select the format cells and go to Custom and set what ever format you want

   
Reply to Sri
Ask your question Reply
They need your help