Search : in
By :

DATE FORMAT IN EXCEL-2007

Last answer on Jan 21, 2009 12:17:05 pm GMT PANKAJ, on Nov 26, 2008 8:13:46 am GMT 
 Report this message to moderators

Hello,

i want to know that howcan i change the dateformat in
excel 2007 worksheet if i want it like :-

monday,1dec.2008

plz. answer me soon.

regards
pankaj

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « DATE FORMAT IN EXCEL 2007 » in :
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¯+...
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
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

anonymos, on Jan 21, 2009 12:13:11 pm GMT

1. Select a cell to be formatted i specific date format.
2. Right click and choose "Format Cells...".
3. In the "Number" tab select "Custom" and type the format you want. For example: dd.mm.yyyy
4. Click "OK" button.

   
Reply to anonymos

2

 anonymos, on Jan 21, 2009 12:17:05 pm GMT
  • +3

Step 3 is applicable if date formats provided by default are not what you want.

In most cases following will work fine:

In the "Number" tab select "Date" and from "Types" list select the most applicable one.

   
Reply to anonymos
Ask your question Reply
They need your help